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

[Reagan · Accepted solution]

Hello

There is no problem in extending a tablespace with additional datafiles across multiple /oracle/SID/sapdataX filessystems. As long as there is space in the sapdataX filesystems then you can add data files.

Regards

RB