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
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