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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL+ and long named files : WARNING !

Re: SQL+ and long named files : WARNING !

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 21 Jul 1998 06:43:41 GMT
Message-ID: <6p1dau$j7n$1@news02.btx.dtag.de>


Hi,

16-bit SQL+?

Patrick Marcouly schrieb:
>
> Hello all.
>
> I'm a newbie and I've got a bad surprise today : SQLplus (my version is
> 3.3.2.0.2) can't manage files with names longger than 8 letters.
>
> Whatever the file name is, if it's longger than 8 lettres, SQLplus truncate
> the name to 8 positions.
>
> Exemple : if I write @c:\makebase2.SQL; , SQLplus will not say me something
> like "invalid file name", but it will do as I writed @c:\makebase.sql;
> forgetting my 9th letter.
>
> Bad luck : I had two files in my directory (MAKEBASE.SQL and MAKEBASE2.SQL)
> and SQLplus executed the wrong one, making big trouble in my database.
>
> So warning other newbies, never use long file names with SQLplus (in that
> version)!
>
> What about SQLplus in version 8 ?

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\


Received on Tue Jul 21 1998 - 01:43:41 CDT

Original text of this message

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