Cannot rename tempfile

From: "astalavista" <nobody@xxxxxxxxxxx>
Date: Thu, 29 Nov 2007 21:33:22 +0100

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

.

Follow-Ups:
- Re: Cannot rename tempfile
  - From: fitzjarrell@xxxxxxx

Prev by Date: Re: showing set events
Next by Date: Re: SGA
Previous by thread: AFTER CREATE trigger (object actually being REPLACED)
Next by thread: Re: Cannot rename tempfile
Index(es):
- Date
- Thread

Relevant Pages

Re: Cannot rename tempfile
... I try to rename files from a database ... it is OK for all datafiles ... but for tempfiles I got the error below: ...
(comp.databases.oracle.server)
Oracle 9i - database cannot open due to UNDOTBS01
... coldbackup of all the datafiles, ... and spfile of my database. ... not backup was the UNDO. ... be located and that the controlfile is more recent than the older ...
(comp.databases.oracle.server)
[HPADM] SUMMARY: RE: How to extract lines from a file using sed without using line numbers.
... # parameters and can be included in the database initialization file. ... # control file and uses it to open the database. ... # the current versions of all online logs are available. ... # Commands to add tempfiles to temporary tablespaces. ...
(HP-UX-Admin)
[HPADM] How to extract lines from a file using sed without using line numbers.
... # parameters and can be included in the database initialization file. ... The first set opens ... # the current versions of all online logs are available. ... # Commands to add tempfiles to temporary tablespaces. ...
(HP-UX-Admin)
Re: SAME(stripe an mirror everything) - where to put binaries and redos?
... (oracle install and all datafiles control files,.....) ... The filesystem issue is irrelevant if all filesystems live on one ... Even if you have only one logical disk I would create a separate mount ... point for the software and for the database files. ...
(comp.databases.oracle.server)