Re: Error when renaming tempfile

"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'
>

If it helps any, here is the DDL for the tablespace.

CREATE TEMPORARY TABLESPACE ts_temp
TEMPFILE 'c:\disk1\ts_temp.dbf'
SIZE 20M
REUSE
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 64K
;

--
Later,
BEDick