Re: Setting the work directory in SQL*PLUS

[Quoted] There is a working directory and a script path.

You can set the working directory with a shortcut, as you have done. Tell us [Quoted] how this does not work. If this directory is not on your local drive, you may not have network permission to write or even read it. You could also open a dos window, go to the desired directory, and run oracle_home\bin\plus80w, but ... bleah. Of course, that would not solve any [Quoted] network permission problem.

The script path is defined in the windows registry. Look in Hkey_Local_Machine\Software\Oracle for SQLPATH. This is a typical PATH variable that allows you to list multiple directories separated by semicolons. The 'run' command in sqlplus will search this path list, but save and get do not (unless the working directory is included in the path, of course.)

[Quoted] "Emile de Bruijn" <e.v.debruijn_at_kpn.com> wrote in message news:01bfb9ae$1fcc8b50$55f015ac_at_HKTGV9911111303...
> Hi all,
>
> At my work I have to start SQL*PLUS from a network drive (no write
 rights).
> Normaly I set the "working directory" with a shortcut on my desktop. But,
> probably because of the network drive it is not working (I do know Save
 As
> and search for the right directory and then choose Cancel). Is it possible
> to set the working directory with a SET statement in SQL*PLUS? Or does
> someone knows an other solution?
>
> Regards,
>
> Emile
Received on Tue May 09 2000 - 00:00:00 CEST