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 -> Re: Cannot rename tempfile

Re: Cannot rename tempfile

From: <fitzjarrell_at_cox.net>
Date: Thu, 29 Nov 2007 13:43:50 -0800 (PST)
Message-ID: <cab26af9-914e-4095-8ff6-664db07d959a@w28g2000hsf.googlegroups.com>


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

Original text of this message

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