Re: sqlplus default script directory
Date: Mon, 03 May 2004 10:56:28 GMT
Message-ID: <wzplc.9488$TT.1474_at_news-server.bigpond.net.au>
"massimo874" <massimo874_at__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 - 12:56:28 CEST