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/