Point individual schemas to different data directories
Posted by: Vivek Devalkar
Date: August 01, 2023 07:47AM

We have a database on a server with 2 TBs of disk space. The database consists of multiple schemas.

We are now running out of drive space and have been told by IT that the drive space cannot be increased further. We do have another drive on the server that has space.

Is it possible to move the data files of some of the schemas to the new drive and point them to this new location.

As far as I can tell, you can only change the drive of the entire data file location not individual schemas but perhaps there are other options.

Options: ReplyQuote

Written By
Point individual schemas to different data directories
August 01, 2023 07:47AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.