Re: oracle spool in Windows environment

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>