"Whatever" <Gan_spam_ar_bith_at_ireland.com> wrote in message
news:iqoe319q9da24hci3qud9tfjlqt6tqqs2j_at_4ax.com...
>
>
>
> Hi all,
>
> I am currently trying to learn Oracle, but I can't figure out how to
> change my working directory.
>
> I have scripts in G:\Paul, so at the prompt in SQL *Plus, I issued the
> command
>
> host cd g:\paul.
what do you want. To run sqlplus when you are currently in g:\paul or to
specify where you run scripts from so you don't have to type the full path?
If it is the latter, my guess is that it is, and you are on windows which
seems likely then you need to edit the sqlpath setting in the registry under
HKLM\SOFTWARE\ORACLE\(some easily discovered key which varies according to
version). this registry key takes a ; separated list of directories and
searches them in order when you wish to run a script using start or @ in
sqlplus.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Wed Mar 16 2005 - 14:25:40 CST
