Re: Error when renaming tempfile

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Tue, 12 Mar 2002 08:54:37 +1100
Message-ID: <lE9j8.9385$uR5.14865@newsfeeds.bigpond.com>

I'm assuming you have used the 8i temporary files, i.e. this file shows up when you query DBA_TEMP_FILES. You can't rename locally managed temporary files, just as you can't recover them. However this is not a problem as being a temporary file means that no data is stored in them. So for your move just drop and recreate the tablespace.

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"bdick" <bdick_at_cox.net> wrote in message news:Rf9j8.7847$E_3.836769_at_news2.east.cox.net...
> 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:54:37 CST