Re: Cannot rename tempfile

On Nov 29, 2:33 pm, "astalavista" <nob...@xxxxxxxxxxx> 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
.

Relevant Pages