oracle12C可以实现在线move数据文件,使得我们rename file方便了很多

SQL> select file#,name from v$datafile;
     FILE# NAME
---------- -------------------------------------------------------------------------------------
         1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
         3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
         4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
         6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 6 to '/tmp/users.dbf';
Database altered.
SQL> select file#,name from v$datafile;
     FILE# NAME
---------- -------------------------------------------------------------------------------------
         1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
         3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
         4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
         6 /tmp/users.dbf
SQL> alter database move datafile 6 to '/opt/app/oracle/oradata/ORA12C/datafile/users.dbf';
Database altered.
SQL> select file#,name from v$datafile;
     FILE# NAME
---------- -------------------------------------------------------------------------------------
         1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
         3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
         4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
         6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 1 to '/tmp/system.dbf';
Database altered.
SQL> select file#,name from v$datafile;
     FILE# NAME
---------- -------------------------------------------------------------------------------------
         1 /tmp/system.dbf
         3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
         4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
         6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 1 to '/opt/app/oracle/oradata/ORA12C/datafile/system.dbf';
Database altered.
SQL> select file#,name from v$datafile;
     FILE# NAME
---------- -------------------------------------------------------------------------------------
         1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
         3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
         4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
         6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf