shutdown immediate
startup mount
alter database rename datafile 'c:\oracle\oradata\xxx.ora' to
'c:\oradata\xxx.ora'
alter database open
startup mount
alter database rename datafile 'c:\oracle\oradata\xxx.ora' to
'c:\oradata\xxx.ora'
alter database open
然后把你需要移动的数据文件复制到目标位置
最后启动数据库执行以下命令:
startup mount
alter database rename datafile 'c:\oracle\oradata\xxx.ora' to
'c:\oradata\xxx.ora';
alter database open