sql> select file_name from sys.dba_data_files;file_name--------------------------------------------------------------c:/ora8/oradata/oracle/users01.dbfc:/ora8/oradata/oracle/dr01.dbfc:/ora8/oradata/oracle/tools01.dbfc:/ora8/oradata/oracle/indx01.dbfc:/ora8/oradata/oracle/rbs01.dbfc:/ora8/oradata/oracle/temp01.dbfc:/ora8/oradata/oracle/system01.dbf
c:/svrmgrl(回车)svrmgr>connect internal(回车)svrmgr>shutdown immediate(回车)#等待数据库提示关闭svrmgr>exit
svrmgr>connect internal(回车)
svrmgr>startup mount(回车)
#等待数据库提示装载成功
svrmgr>alter database rename file 'c:/ora8/oradata/oracle/users01.dbf' to 'd:/oradata/users01.dbf';
#提示语句已处理后,如果要移动多个文件,修改文件路径和名称后重复执行上面的语句。完成后打开数据库。
svrmgr>alter database open;
svrmgr>exit
新闻热点
疑难解答