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: Collin Leung <collinl_at_vtc.edu.hk>
Date: Tue, 21 Jul 1998 10:56:00 +0800
Message-ID: <6p102p$lcd@is1.vtc.edu.hk>


My SQLPlus version is 3.3.2.0.2 and oracle version is 8.03

But I don't have such problem, I can execute the sql which file name is more than 8.

Collin :P

Patrick Marcouly wrote in message
<6p07kc$koe$1_at_pegase.production.axime.fr>...
>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 ?
>
>
>
>
>
Received on Mon Jul 20 1998 - 21:56:00 CDT

Original text of this message

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