error trying to rename datafile

Giganews Newsgroups
Subject: error trying to rename datafile
Posted by:  Eugene (epip…@gmail.com)
Date: Sun, 22 Jul 2007

Hi all,
What may cause the following error?
-------------------------------------------------------------
select file_name
from dba_data_files
where
tablespace_name = 'XLARGE_DATA';

G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_01.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_02.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_03.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_04.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_05.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_06.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_07.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_08.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_09.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_10.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_11.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_12.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_12.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_13.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_14.DBF
L:\ORACLE\ESST\DATA\ESST_LARGE_DATA_15.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_INDX_13.DBF

........
shutdown immediate;
......
startup mount;
......
ALTER DATABASE RENAME FILE 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF' TO 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_DATA_16.DBF';

ALTER DATABASE RENAME FILE 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF' TO 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_DATA_16.DBF'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 114 - new file
'L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_16.DBF' not found
ORA-01110: data file 114: 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Thanks,
Eugene

Replies