Oracle 重命名数据文件的两种方法：ALTER TABLESPACE RENAME DATAFILE和ALTER DATABASE RENAME FILE

　　语法

　　ALTER DATABASE RENAME FILE 'old_name' to 'new_name'

　　ALTER TABLESPACE tablespace_name RENAME DATAFILE 'old_name'  TO 'new_name'

　　通过这两种方法重命名数据文件必须保证目标文件存在(The operating system files continue to exist),数据库在open状态下重命名数据文件必须保证要重命名的数据文件所在的表空间处于offline的状态，由于在open状态下system和sysaux表空间不能够被offline，所以在open状态只能重命名除去system和sysaux之外的数据文件。

　　ALTER DATABASE RENAME FILE 不仅仅可以重命名数据文件，同样可以重命名tempfiles, or redo log file

　　重命名数据文件示例如下:

　　SQL> select file_name,tablespace_name,status from dba_data_files;

　　FILE_NAME                                                      TABLESPACE_NAME                STATUS

　　-------------------------------------------------------------- ------------------------------ ---------

　　/u01/dbabc.net/pass/users01.dbf                          USERS                          AVAILABLE

　　/u01/dbabc.net/pass/sysaux01.dbf                         SYSAUX                         AVAILABLE

　　/u01/dbabc.net/pass/undotbs01.dbf                        UNDOTBS1                       AVAILABLE

　　/u01/dbabc.net/pass/system01.dbf                         SYSTEM                         AVAILABLE

　　/u01/dbabc.net/pass/example01.dbf                        EXAMPLE                        AVAILABLE

　　/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_passt_6dlc02ws_.dbf   PASST                          AVAILABLE

　　/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_tp_6dlc7pd7_.dbf      TP                             AVAILABLE

　　/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_users1_6dlccg3l_.dbf  USERS1                         AVAILABLE

　　/u01/dbabc.net/dbs/hr_tbs01.dbf                              HR_TBS                         AVAILABLE

　　/u01/dbabc.net/dbs/testdefault01.dbf                         TEST_DEFAULT                   AVAILABLE

　　10 rows selected

　　SQL>

　　重命名PASST tablespace下的 /dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_passt_6dlc02ws_.dbf的数据文件

　　1、首先将PASST tablespace offline

　　SQL> alter tablespace passt offline;

　　Tablespace altered

　　2、重命名数据文件(OS)

　　[dbabc.net]cd /dbabc.net/pass/passt/omf/PASS/datafile

　　[dbabc.net]mv o1_mf_passt_6dlc02ws_.dbf /dbabc.net/pass/passt_01.dbf

　　[dbabc.net]cd /dbabc.net/pass/

　　[dbabc.net]ll passt_*

　　-rw-r----- 1 oracle oinstall 104865792 Nov  5 08:38 passt_01.dbf

　3、ALTER TABLESPACE tablespace_name RENAME ‘old_name’ to ‘new_name’

　　SQL> ALTER TABLESPACE passt

　　2          RENAME DATAFILE '/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_passt_6dlc02ws_.dbf'

　　3           TO '/dbabc.net/pass/passt_01.dbf';

　　Tablespace altered

　　4、将表空间online

　　SQL> alter tablespace passt online;

　　Tablespace altered

　　5、确认一下

　　SQL> select file_name,tablespace_name,status from dba_data_files;

　　FILE_NAME                                                      TABLESPACE_NAME                STATUS

　　-------------------------------------------------------------- ------------------------------ ---------

　　/u01/dbabc.net/pass/users01.dbf                          USERS                          AVAILABLE

　　/u01/dbabc.net/pass/sysaux01.dbf                         SYSAUX                         AVAILABLE

　　/u01/dbabc.net/pass/undotbs01.dbf                        UNDOTBS1                       AVAILABLE

　　/u01/dbabc.net/pass/system01.dbf                         SYSTEM                         AVAILABLE

　　/u01/dbabc.net/pass/example01.dbf                        EXAMPLE                        AVAILABLE

　　/dbabc.net/pass/passt_01.dbf                                        PASST                          AVAILABLE

　　/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_tp_6dlc7pd7_.dbf      TP                             AVAILABLE

　　/dbabc.net/pass/passt/omf/PASS/datafile/o1_mf_users1_6dlccg3l_.dbf  USERS1                         AVAILABLE

　　/u01/dbabc.net/dbs/hr_tbs01.dbf                              HR_TBS                         AVAILABLE

　　/u01/dbabc.net/dbs/testdefault01.dbf                         TEST_DEFAULT                   AVAILABLE

　　10 rows selected

　　SQL>