1.数据文件迁移
将表空间offline:
alter tablespace users offline;
!cp -v ?/user01.dbf /u01/
alter tablespace users rename datafile '?/user01.dbf' to '/u01/user01.dbf';
对System表空间不能offline:
shutdown immediate;
startup mount;
!cp -v ?/system01.dbf /u01/
alter database rename file '?/system01.dbf' to '/u01/system01.dbf';
alter database open;
2.控制文件移动方法:
create pfile='/u01/orcl.ora' from spfile;
shutdown immediate
!cp -v ?/control01.ctl /u01/control01.ctl
编辑orcl.ora修改控制文件新位置
startup mount pfile='/u01/orcl.ora'
create spfile from pfile='/u01/orcl.ora';
alter database open;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29677883/viewspace-1170222/,如需转载,请注明出处,否则将追究法律责任。