Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cannot rename tempfile

Cannot rename tempfile

From: astalavista <nobody_at_nowhere.com>
Date: Thu, 29 Nov 2007 21:33:22 +0100
Message-ID: <474f2212$0$6155$426a74cc@news.free.fr>


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 Received on Thu Nov 29 2007 - 14:33:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US