Point individual schemas to different data directories
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.
Subject
Written By
Posted
Point individual schemas to different data directories
August 01, 2023 07:47AM
Sorry, you can't reply to this topic. It has been closed.
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.