Wednesday, January 27, 2016

steps to move oracle Data file online one location to another location in oracle 12c

In Oracle 12c  we can move Oracle  data file online.
Here is the steps for online movement.

SQL*Plus: Release 12.1.0.1.0 Production

SQL> select  file_name from dba_data_files where file_name like '%users01%';

FILE_NAME
--------------------------------------------------------------------------------

/u01/app/oracle/oradata/source/users01.dbf


SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/source/users01.dbf' to '/u02/app/oracle/oradata/source/users01.dbf';

Database altered.

SQL> select  file_name from dba_data_files where file_name like '%users01%';

FILE_NAME
--------------------------------------------------------------------------------

/u02/app/oracle/oradata/source/users01.dbf

No comments:

Post a Comment