Tablespace datafiles in multiple filesystems

[#1]

Hello,

I'll try to keep my first discussion/question as brief as possilbe,

One of our ext4 filesystems (RHEL 6.2) that houses a near-max-size tablespace (Oracle 11g) is exhausted, expanding it is a viable option, however that raised a question in my head, what would be the implications of extending this tablespace with a datafile that would reside on a different filesystem, i.e. different /sapdata# filesystem? As far as my little knowledge goes, it's doable, however wanted to know if there could be any downsides.

Best regards

[Former Member]

Hi Salesh,

Have Different data files of a tablespace in different in File Systems is common practise, There is no harm at all..

You can perfectly use it.

Regards,

Shivam