| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Error when renaming tempfile
Oracle 8.1.7
Windows2K
I am moving my database files to different disk drives and everything is fine for the datafiles and logfiles. But when I try to rename a tempfile I get an error. I double checked the spelling and the file exists in both the old and new location. What else could be wrong?
alter database rename file 'C:\DISK1\TS_TEMP.DBF' to 'C:\DISK0\TS_TEMP.DBF'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile or tempfile 'C:\DISK1\TS_TEMP.DBF'
-- Later, BEDickReceived on Mon Mar 11 2002 - 15:24:01 CST
![]() |
![]() |