Hi all,
I've copied all files of a database to other server. so I've generated alter database renam file
to datafiles, redo log files and temp files.
But, when I try to do an alter database renam file for temp file, I get the following error:
SQL> ALTER DATABASE RENAME FILE '/opt/oracle/data/temp01.dbf'
TO 'NEW_ORACLE/data/temp01.dbf'; 2
ALTER DATABASE RENAME FILE '/opt/oracle/data/temp01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile "/opt/oracle/data/temp01.dbf"
But I can see the temp files by using the view v$tempfile.
Somebody can help me please???
thank you very much!!!!
PS.: The database is mounted.