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 datafile with a carriage return in the filename

411002May 30 2006 — edited May 30 2006

How can I rename a datafile with a carriase return in the filename? I have a tablespace with 3 data files, they look like this:
/oracle/oradata/orcl/staging_data_01.dbf
/oracle/oradata/orcl/staging_data_02.dbf
/oracle/oradata/orcl/
staging_data_03.dbf

The staging_data_03.dbf filename is actually a chr(10) 4 spaces then staging_data_03.dbf. When I look at the directory in linux OS prompt this datafile looks like this:
? staging_data_03.dbf
It looks like linux replaced the carriage return with a ?. How can I rename this datafile to remove the carriage return and spaces?

I actually found this when doing a practice disaster recovery and it couldn't create this datafile.

Help please?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2006

Added on May 30 2006

#general-database-discussions

9 comments

477 views