Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename the datafile which has special characters.

RobinJan 27 2010 — edited Feb 14 2013
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2013
Added on Jan 27 2010
16 comments
5,194 views