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

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 - 13:55:18 CDT