重命名数据库文件
时间:2010-07-26 来源:r55wen
alter tablespace users offline;
host
mv /u01/oradata/sean/user01.dbf user02.dbf
alter tablespace users rename datafile '/u01/oradata/sean/user01.dbf' to '/u01/oradata/sean/user02.dbf';
alter tablespace users online;
host
mv /u01/oradata/sean/user01.dbf user02.dbf
alter tablespace users rename datafile '/u01/oradata/sean/user01.dbf' to '/u01/oradata/sean/user02.dbf';
alter tablespace users online;
相关阅读 更多 +