Re: Error when renaming tempfile

The "CREATE TEMPORARY TABLESPACE" shows that my assumption was correct. Please see my other post for the answer to your problem.

Kind Regards

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"bdick" <bdick_at_cox.net> wrote in message news:4x9j8.7856$E_3.840724_at_news2.east.cox.net...
> "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
>
>
>
Received on Mon Mar 11 2002 - 15:56:18 CST