SQL*PLUS: change default directory

[fmorel]

Hi!
How do you change SQL*PLUS default directory.

For example, when I do @myfile.sql, I would like Sql*plus to search it in another directory than SQL*PLUS default one.

With SQL*PLUS Windows version, I do a "File - Open", and then the last directory becomes the default directory.
How can I do this in a MS/DOS or Unix version ?

 

[stefes007]

I know some solutions for you:

you can always do:

spool c:\windows\desktop\aa.lis

or in unix

spool /home/me/a.lis

second solution is in windows :

Right click the icon of SQL*PLUS -> Properties -> Shorcut and change the start in filed: the directory you write in there will be the start directory ...

In unix, the start directory is the directory where you typed in the "sqlplus" command ...

Dekeyzer Stephane.
Belgium

 

[sem]

You should define environment variable SQL_PATH to point to the directory your script is located in. You may separate entries by semicolon. On Windows you may create a registry entry under Oracle key (under an appropriate Oracle home if more than one)

 

[fmorel]

Thank you !