SQL> shutdown immediate;
SQL> exit;
然后用oracle用户拷贝文件 [oracle@my]$ mv /dir1/lncrmbak/TEMP02.dbf /oradata/TEMP02.dbf拷贝完毕后再执行执行sqlplus / as sysdba,进入sqlplus SQL> startup mount; SQL> alter database rename file '/u01/app/oracle/oradata/sid/TEST.dbf' to '/u02/app/oracle/oradata/sid/TEST.dbf'; ERROR at line 1:ORA-01511: error in renaming log/data filesORA-01516: nonexistent log file, datafile, or tempfile "/dir1/lncrmbak/TEMP02.dbf"以上是操作过程 怀疑临时表空间不能迁移?请教各位是这样吗?我想迁移临时表空间应该怎么操作 谢谢