Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control Chars in Filename
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).
That sounds awfully close to the escape key on a VT-220.
>
> 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'.
Get Unix Power Tools by Peek, et. al. Hours of fun, and explanations of all the weird stuff you didn't know why you did.
>
> 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.
jg
-- @home is bogus. 12354, 00000, "secondary object being dropped" // *Cause: You tried to access a object (for example, a table or view) // on a secondary database that was in the process of being // dropped. // *Action: Repeat the operation. If you receive this message again, try to // access the object from the secondary database. If you receive // an internal error or a trace file, contact Oracle WorldWide // Technical Support.Received on Thu Oct 31 2002 - 15:59:12 CST