Migrating Data Files Steps

Select File#,name,status from V$datafile;

SELECT * from V$tablespace;

1. Alter tablespace AAA offline;

2. Shutdown immediate;

3. Copy data file to Destination directory

4. Startup Mount;

Alter DATABASE rename file ' F:\ORACLE\ORADATA\ORCL\AAA_01.DBF ' to ' H:\ORACLE\ORADATA\ORCL\AAA_01.DBF ';

5. Alter DATABASE open;

6. Alter tablespace AAA Online; --note that there may be an IO-related error when performing this step because the data file copy has not been written, and the workaround is to re-assign the files to the Oracle account read and Write permissions.


Note:oracle 12C supports online migration of data files

Migrating Data Files Steps