Re: Newbie question - how do I choose my working directory?

Whatever (Gan_spam_ar_bith_at_ireland.com) wrote:

: 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.

: The dos window popped for a second and SQL *Plus didn't complain, but
: when I issued a

: host dir /w command, I was still in the SQL *Plus bin directory, and I
: definitely don't want to go messing round in there.

: How do I make this change? TIA.

1)

set the current directory before you start sqlplus

1. if you click on an icon to start sqlplus then examine the properties of the icon. You should be able to set the directory.
2. if you start from the command prompt then simply CD to the desired directory and then type the sqlplus command.

2)

In the windows version of sqlplus, you can also set your current directory after you start as follows

        use the menus

        file:Spool:Spool File...

        navigate to a directory, enter a spool file name, and press SAVE

        That will now be the working directory for sqlplus.

        You may wish to close the spool file, it doesn't matter either way

                SQL> spool off

I haven't used this in the most recent versions of sqlplus for windows (>=10, not sure about 9), but it's been true for a long time in earlier versions (and is very useful so I hope it still works).

--

This space not for rent.