Re: sqlplus default script directory

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 03 May 2004 10:56:28 GMT
Message-ID: <wzplc.9488$TT.1474@news-server.bigpond.net.au>

"massimo874" <massimo874@_SPAMMATUAMAMMA_inwind.it.invalid> wrote in message news:A1plc.33736$eR5.21687_at_tornado.fastwebnet.it...
> Please some one can tell me wich is the SQLPlus default script directory
an
> how I can set it.
> I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.
>
> WinXP, ORACLE 9i.
>
>

See p.A-2 of the "Oracle 9i Windows SQL*Plus Getting Started" manual. (A92157-01)

The default SQLPlus directory is %ORACLE_HOME%\dbs

The following method works as well:
Open 'CONTROL PANEL'
Open 'System'
Select 'Advanced' tab
Click on 'Environment Variables'
Click on 'New' under 'System Variables'
Variable Name is 'SQLPATH' and the value is a list of directories separated by semicolons ';'.

Douglas Hawthorne Received on Mon May 03 2004 - 05:56:28 CDT