Re: carriage return in datafile name

If you mean that you have dropped the tablespace successfully and need to remove the OS file ....  

suppose the name of the file is xxxxxx<CR>, WHERE <CR> is the carriage return ...
You can (pick one of the following)

1. rm -i xxxxxx* # enter 'y' when the file is prompted. OR
2. ls -i xxxxxx* # gets the inode of file in question,

                                           # assume you see something 
                                           # like  "9999 xxxxxx<CR>"
    find . -inum 9999 -exec rm {} \;
                                          # removes the file at inode
                                          # 9999, which is xxxxxx<CR>!

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.