Rename the datafile which has special characters.
RobinJan 27 2010 — edited Feb 14 2013Hi,
In AIX server, I have added a datafile and unknownly special characters are added due to given backspace.Now i want to rename the datafile which has special character to correct file name.
The file name is :
ls -ltr
-rw-rw---- 1 oracle dba 52436992 Jan 27 03:44 test_0001.dbf
ls -b (special character details)
test_0001\010\010.dbf
mv test_0001* test_correct.dbf
But in db ,if fire the rename command,I am getting the below error.
1.
alter database rename file '/oracle/u01/test_0001.dbf' to '/oracle/u01/test_correct.dbf';
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/oracle/u01/test_0001.dbf"
2.alter database rename file '/oracle/u01/test_0001\010\010.dbf' to '/oracle/u01/test_0001.db.dbf';
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/oracle/u01/test_0001\010\010.dbf"
Please help me to solve this issue.Your help is really appricated.
Thanks
Sai