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 some datafiles

Cannot rename some datafiles

From: astalavista <nobody_at_nowhere.com>
Date: Wed, 24 Oct 2007 21:26:47 +0200
Message-ID: <471f9c70$0$26703$426a74cc@news.free.fr>


Hi,

I rename about 50 datafiles
(database in mount state)

some datafiles can't be renamed
I don't know why
Can you help me ?
(9.2.0.6)

Thanks in advance

SQL> /
alter database rename file '/prd/data/ora/P95/03/P95_dwh_dat11.dbf' to '/prd/data/ora/P100/03/P100_dwh_dat11.dbf' *
ERROR at line 1:
ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, datafile, or tempfile "/prd/data/ora/P95/03/P95_dwh_dat11.dbf"

SQL> !ls -l /prd/data/ora/P95/03/P95_dwh_dat11.dbf -rw-r----- 1 oracle dba 2095939584 Oct 24 14:48 /prd/data/ora/P95/03/P95_dwh_dat11.dbf

SQL> !ls -l /prd/data/ora/P100/03/P100_dwh_dat11.dbf -rw-r----- 1 oracle dba 2095939584 Oct 24 12:30 /prd/data/ora/P100/03/P100_dwh_dat11.dbf Received on Wed Oct 24 2007 - 14:26:47 CDT

Original text of this message

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