On Nov 29, 2:33 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I try to rename files from a database
> the database is in mount state
> it is OK for all datafiles
> but for tempfiles I got the error below:
>
> alter database rename file '/prd/data/ora/P200/02/P200_temp01.dbf' to
> '/prd/data/ora/P200/02/P100_temp01.dbf'
> *
> ERROR at line 1:
> ORA-01511: error in renaming log/data files
> ORA-01516: nonexistent log file, datafile, or tempfile
> "/prd/data/ora/P200/02/P200_temp01.dbf"
>
> I am sure the files exist.
> Bug or feature ?
> Thanks for your lights
> 9.2.0.6/AIX 5.3
I'd be looking in dba_temp_files to see if this file is in your
database. According to Oracle it isn't, as this does NOT rename
operating system files, it merely alters the entry in the controlfile.
David Fitzjarrell
Received on Thu Nov 29 2007 - 15:43:50 CST
