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: Joel Garry <joel-garry_at_home.com>
Date: 31 Oct 2002 13:59:12 -0800
Message-ID: <91884734.0210311359.6955ab96@posting.google.com>


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

Original text of this message

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