Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle spool in Windows environment
there is of course the SQLPATH environment variable for script locations.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Andy Hassall" <andy_at_andyh.co.uk> wrote in message news:c15q20dqf83649tsdkckrgp88t6jtv0t01_at_4ax.com...Received on Fri Feb 13 2004 - 14:19:00 CST
> On 13 Feb 2004 08:28:24 -0800, ken.quirici_at_excite.com (ken quirici) wrote:
>
> >I'm trying to figure out how to change the default directory for spool
> >so that when I 'spool <filename>' it'll go where I want it to. I know
> >that if I type the full path name (e.g. spool c:\problem\test.log), it'll
> >go there. I just don't want to have to type in the full path everytime.
> >I'm on a windows 2000 machine running oracle SQLPLUS 8.0. The default
directory
> >right now is c:\oracle805\BIN.
> >
> >I'd like a solution that would also change the default directory for
> >EDIT and @.
>
> The default directory is the operating system's current working
directory. It
> sounds like you're running SQL*Plus from a Windows shortcut? If so, by
default
> shortcuts change the working directory to the directory containing the
> shortcut's target. Right click the shortcut, choose Properties, and change
the
> "Start In" entry to the directory you want as default.
>
> Or, if you're actually running it from a command prompt, change directory
to
> the place you want to save your files by default, and then run sqlplus
using a
> full path, e.g. c:\oracle805\bin\sqlplus.exe , or add c:\oracle805\bin to
your
> PATH environment variable so you can run sqlplus from any directory.
>
> Plus the standard reply: Oracle 8.0 has been desupported for ages, and I
don't
> think was ever certified on Windows 2000 at all. Upgrade if possible.
>
> --
> Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
> <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>