peter_at_nomorenewsspammin.ca said...
> Sqlplus is complaining that it cannot find my scipts.
> Can I specify where the scripts are in the sql command?
>
I assume you're referring to the GUI sqlplus. Allison's response is
correct (of course, since she's the one who's in charge of sqlplus).
However, there are a couple of other things you can do in addition to
specifying the full path to the script.
- Do a File / Open... and navigate to any script in the directory where
you script is. It will display on your screen; but more importantly, it
will set the working directory to wherever you opened the file. Ctrl-C
to exit, and then do your @script (path no longer needed).
- Alternatively, you can tell where sqlplus will look for script files
by typing 'host' (without quotes). That will open a DOS window to the
place where it's expecting to see the scripts. Of course, you'll then
realize that it's the place you specified in the shortcut's properties
page for the "starting in" parameter. So you can right-click your
sqlplus shortcut icon, select Properties, and set your starting
directory to where your scripts are. Then the next time you start
sqlplus from that shortcut, you'll be where your scripts are.
--
/Karsten
DBA > retired > DBA
Received on Tue Apr 22 2003 - 11:22:22 CDT
