By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,196 Members | 973 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,196 IT Pros & Developers. It's quick & easy.

sqlplus default script directory

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"massimo874" <massimo874@_SPAMMATUAMAMMA_inwind.it.invalid> wrote in message
news:A1*******************@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
Jul 19 '05 #2

P: n/a
thank you

"Douglas Hawthorne" <do**************@yahoo.com.au> ha scritto nel messaggio
news:wz****************@news-server.bigpond.net.au...
"massimo874" <massimo874@_SPAMMATUAMAMMA_inwind.it.invalid> wrote in message news:A1*******************@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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.