oracle spool in Windows environment

From: ken quirici <ken.quirici_at_excite.com>
Date: 13 Feb 2004 08:28:24 -0800
Message-ID: <a5cb05d5.0402130828.3f4672c4@posting.google.com>

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 Received on Fri Feb 13 2004 - 10:28:24 CST