Re: oracle spool in Windows environment

ken quirici wrote:

> Hi,
>
> 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 @.
>
> Thanks for any help.
>
> Ken Quirici

spool c:\temp\myspoolfile.lst

Just specify the path.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)