Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Control Chars in Filename

Re: Control Chars in Filename

From: Matthias Rogel <rogel_at_web.de>
Date: Mon, 04 Nov 2002 11:10:49 +0100
Message-ID: <aq5h3a$6oo22$1@ID-86071.news.dfncis.de>


I prefer

find . -name "abc*" -type f -ok rm {} ';'

mr

Eric Parker wrote:
> Another solution (assuming the filename is "abc<unknown characters>xyz.dbf")
> is to enter
>
> rm -i abc*xyz.dbf
>
> then pressing y or n appropriately as prompted.
>
> eric
>
> "Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
> news:apqkm2$2dl$1_at_ctb-nnrp2.saix.net...
>

>>Ran into a very interesting problem yesterday. Had to do an offline drop

>
> of
>
>>a datafile. Only, when this datafile was created, there must have been
>>finger trouble via the telnet session that was used to do the add

>
> datafile.
>
>>V$DATAFILE showed the filename. Used that name. Oracle said the

>
> datafilename
>
>>is unknown. Alert log showed the filename as having a control character,
>>e.g. ..../^[[2~filename.dbf  (showed up as .../filename.dbf in the V$
>>table).
>>
>>How do you drop the datafile?
>>
>>After some minutes of fruitless attempts, asked a Unix guy and he showed
>>how. Thought that this is the type of info one needs to file under 'never
>>forget'.
>>
>>Create a sh script in vi and do the drop file statement there. Type the
>>filename as it appears and use vi to create the contol chars. Press CTRL-V
>>in vi. Keep CTRL down and enter the control char, e.g. CTRL-V [ for the

>
> ^[[
>
>>bit.
>>
>>
>>
>>--
>>Billy

>
>
>
Received on Mon Nov 04 2002 - 04:10:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US