Re: carriage return in datafile name

In article <6ftv0a$jei$1_at_news1.fast.net>,  <mzawadzki_at_starnet.lenfest.com> wrote:
>If you mean that you have dropped the tablespace successfully
>and need to remove the OS file ....

If you mean you can't take it offline because you can't ALTER TABLESPACE 'XYZ<CR>' OFFLINE;

I haven't tried it, but you might be able to concatenate the printable characters to the ascii value in the CHR function. ...'XYZ'||CHR(13) OFFLINE;
>elufker_at_swcp.com wrote:
>
>>Hi All:
>
>
>>Has anyone ever had a datafile with a carriage return as part of the name. I
>>am having a helck of a time dropping this file. I am using Oracle v7.3.3.0
>>running on a solaris 2.5.1 platform. Any hints on how to handle this. I can't
>>get it offline or anything.
>
>
>>thanks
>>eddie lufker
 

>>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>>http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
>Mark Zawadzki, late of Waynesboro, Va.
>'...there is not a sprig of grass that shoots uninteresting to me.'
> Thomas Jefferson, 1790.
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!