ORACLE 重新命名資料檔案

oracle datafile rename 可以採用下述兩種方法：

1. Alter tablespace data file rename

當資料庫處於執行狀態，可以選擇使用先將資料檔案所在表空間置於offline狀態，然後移動資料檔案並重敏命名資料庫檔案，最後將表空間置於online狀態。

We can use the alter tablespace renaume datafile command, but the tablespace most be offline and you must re-name the data file while the tablespace is offline:
step1.  offline operation
    alter tablespace userdata  offline;

step2. move file in os command
    mv  /u01/oradata/CENHELP/userdata1.dbf    /u02/oradata/CENHELP/userdata01.dbf

step3.  rename operation
   alter tablespace userdata rename  datafile  '/u01/oradata/CENHELP/userdata1.dbf'  to    /u02/oradata/CENHELP/userdata01.dbf'

step4. reset online

  alter tablespace userdata online

2. Alter Database data file rename

這種方法當資料庫處於mount狀態的時候應用

We can also use the alter database rename datafile command, but the data file must be renamed in the OS (using the mv linux command) while the database is down and the rename data file must be done while the database is un-opened (in the mount stage):

step1. stop db
shutdown immediate;

step2. move file to new place
mv '/u01/app/oracle/mysid/oldname.dbf' '/u01/app/oracle/mysid/newname.dbfF'

step3. mount db
sqlplus:  startup mount;

step4. rename datafile
ALTER DATABASE
RENAME file     
   '/u01/app/oracle/mysid/oldname.dbf'
TO
   '/u01/app/oracle/mysid/newname.dbf'
step5. open db
alter database open