| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control Chars in Filename
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
>>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
>>V$DATAFILE showed the filename. Used that name. Oracle said the
>>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
![]() |
![]() |