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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21754115/viewspace-1152696/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21754115/viewspace-1152696/