Need help renaming datafile with <cr> in name.

From: <kcary_at_my-dejanews.com>
Date: Wed, 05 May 1999 17:58:30 GMT
Message-ID: <7gq0s3$ude$1@nnrp1.dejanews.com>

Unfortunately, in creating the tablespace for our Enterprise manager repository we hit a return before entering the close quote and contined the create command on the next line in SVRMGR. This created a datafile whose name was, in effect,

oem_data.dbf^M

and this is reflected in file system listings, OEM listings of datafiles, etc.

A simple trick to rename the file in the system (AIX), however, we want to figure out how to do this within Oracle (7.3.2). Unfortunately, the create and rename function seem asymetric--you can create a datafile with the <cr> but can't rename one that has a <cr> in it. The listing at the bottom of this message shows our rename attempt, which is structured the same way as the create statement.

Any thoughts on how to solve this problem? Should we drop the tablespace, delete the file, and recreate the tablespace in a new file?

Thanks much for your thoughts on this!
=ksc

[Note the placement of the close quote from line 2 on line 3; this is the same placement that caused the oem_data.dbf file to be created with <cr> appended to the name.]

SVRMGR> ALTER TABLESPACE "OEM_DATA" OFFLINE NORMAL; Statement processed.

SVRMGR> ALTER DATABASE RENAME FILE
     2> '/emc1/oradata/axis/oem_data.dbf
     3> ' TO '/emc1/oradata/axis/oem_data.dbf';

ALTER DATABASE RENAME FILE
*
ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 9 - new file '/emc1/oradata/axis/oem_data.dbf' not found ORA-01110: data file 9: '/emc1/oradata/axis/oem_data.dbf '
ORA-07360: sfifi: stat error, unable to obtain information about file. IBM AIX RISC System/6000 Error: 2: No such file or directory SVRMGR> ALTER TABLESPACE "OEM_DATA" ONLINE; Statement processed.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 12:58:30 CDT