Move a datafile

July 30, 2012 admin Oracle

If you want to move the tablespace you need to:

1 – Quiecse the tablespace (alter tablespace dba_temp_files offline)

2 – Copy the data file to the new location

3 – Rename the tablespace datafile “alter tablespace dba_temp_files
rename datafile /oracle/temp2 to /oraclenew/temp2”

4 – Bring the tablespace online (alter tablespace dba_temp_files online;

5 – Nuke the old file from the fileysystem (rm temp2)

Comments are currently closed.