how to move temp01.dbf and undotbs01.dbf file?

[dbstudent]

I have moved all my data files to a new location with success except the Temp01.dbf and Undotbs01.dbf. I get the following error when i try to move them.

SQL> alter database rename file 'c:\u01\oracle\oradata\cicada\undotbs01.dbf' to 'c:\u01\oradata\cicada\undotbs01.dbf';
alter database rename file 'c:\u01\oracle\oradata\cicada\undotbs01.dbf' to 'c:\u01\oradata\cicada\undotbs01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"c:\u01\oracle\oradata\cicada\undotbs01.dbf"

Thanks in advance for your help.

 

[KenCunningham]

You are sure that
c:\u01\oracle\oradata\cicada\undotbs01.dbf is still there and hasn't been moved as part of previous moves?

 

[Scunningham99]

check v$datafile and v$tempfile and issue exactly how it is listed in the view.



Sy UK

 

[williey]

For the temp files, you need to drop and recreate the temp file.

SQL> alter database tempfile '<temp file name>' drop including datafiles;

SQL> alter TABLESPACE TEMP ADD DATAFILE '<temp file name>' SIZE xxM;

Birth of OSs is the result of Unix evolution