Oracle rename数据文件的两种方法

Oracle rename数据文件的两种方法备注：红色为原路径紫色为目标路径第一种alter tablespace users rename datafile "==" to ‘***";这种方式需要数据库处于open状态，表空间在offline的状态下才能更改。SQL> alter tablespace users rename datafile "/opt/ora10g/oradata/orcl/user0100.dbf","/opt/ora10g/oradata/orcl/user099.dbf" to "/opt/ora10g/oradata/orcl/userrename1.dbf","/opt/ora10g/oradata/orcl/userrename2.dbf";
alter tablespace users rename datafile "/opt/ora10g/oradata/orcl/user0100.dbf","/opt/ora10g/oradata/orcl/user099.dbf" to "/opt/ora10g/oradata/orcl/userrename1.dbf","/opt/ora10g/oradata/orcl/userrename2.dbf"
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01121: cannot rename database file 107 - file is in use or recovery
ORA-01110: data file 107: "/opt/ora10g/oradata/orcl/user0100.dbf"SQL> alter tablespace users offline;
Tablespace altered.SQL> alter tablespace users rename datafile "/opt/ora10g/oradata/orcl/user0100.dbf","/opt/ora10g/oradata/orcl/user099.dbf" to "/opt/ora10g/oradata/orcl/userrename1.dbf","/opt/ora10g/oradata/orcl/userrename2.dbf";
alter tablespace users rename datafile "/opt/ora10g/oradata/orcl/user0100.dbf","/opt/ora10g/oradata/orcl/user099.dbf" to "/opt/ora10g/oradata/orcl/userrename1.dbf","/opt/ora10g/oradata/orcl/userrename2.dbf"
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01141: error renaming data file 107 - new file "/opt/ora10g/oradata/orcl/userrename1.dbf" not found
ORA-01110: data file 107: "/opt/ora10g/oradata/orcl/user0100.dbf"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3SQL> ！
[oracle@rac1 ~]$ cp /opt/ora10g/oradata/orcl/user0100.dbf /opt/ora10g/oradata/orcl/userrename1.dbf[oracle@rac1 ~]$ cp /opt/ora10g/oradata/orcl/user099.dbf /opt/ora10g/oradata/orc
l/userrename2.dbf
[oracle@rac1 ~]$ exit
exitSQL> alter tablespace users rename datafile "/opt/ora10g/oradata/orcl/user0100.dbf","/opt/ora10g/oradata/orcl/user099.dbf" to "/opt/ora10g/oradata/orcl/userrename1.dbf","/opt/ora10g/oradata/orcl/userrename2.dbf";
Tablespace altered.SQL> alter tablespace users online;
Tablespace altered.

ORA-18008: cannot find OUTLN schemaOracle bbed 恢复无归档的数据库相关资讯 Oracle rename

Oracle 重建表（rename）注意事项总（07/02/2014 20:16:25）

本文评论查看全部评论（0）