Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Cannot rename some datafiles
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
![]() |
![]() |