Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where should place my sql scripts?
"Peter" wrote...
>
> I am rnnning Win2000. sorry that I left that out.
>
> >"Peter" wrote...
> >> Sqlplus is complaining that it cannot find my scipts.
> >> Can I specify where the scripts are in the sql command?
Hi Peter,
my favourite way for doing this is:
- create a shortcut to the GUI sql*plus (e.g. plus80w.exe)
- modify the property working directory in this shortcut
to your needs
- BINGO.
I use this way because I work on many different procects (nearly)
simultaneously. I create shortcuts for every project. That prevents me
from logging into the wrong database etc. It allows me to store specific
scripts in the project's directory structure.
But if your just have one project, I think, setting SQLPATH is the way to go.
Greetings,
Guido
directory and use them
Received on Wed Apr 23 2003 - 01:44:20 CDT