You cannot rename (move) a temporary file from a locally-managed
tablespace.
You have to drop the tablespace and create a new one.
bdick wrote:
>
> 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,
> BEDick
Received on Mon Mar 11 2002 - 15:57:09 CST
