Re: Need help renaming datafile with <cr> in name.

If that doesn't work, use the backup controlfile technique to rename the datafile.

Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories.

Jonathan Lewis wrote in message
<925930665.24704.1.nnrp-04.9e984b29_at_news.demon.co.uk>...
>You could try using dbms_sql to execute the Alter database,
>creating the necessary string using ..... || chr(13) || .....
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>kcary_at_my-dejanews.com wrote in message <7gq0s3$ude$1_at_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.
>
>
>
Received on Wed May 05 1999 - 15:55:13 CDT