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

c:/svrmgrl(回車)
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