How to configure path for SPOOL files?

Hi,

I am running some procedures from sqlplus environment. For example see below script..

SQL> set echo on
SQL> spool capture_drop.out
SQL> @c:\admin\streams\capture_drop.sql

Here the "capture_drop.out" is storing in "C:\" . How can i change this path to another as i required?

My OS is : Windows XP
Oracle:10gR2

Can anybody help me?

Regards
Rajesh

put the full path of where you want the file to go then

Is there no other way to set as default?

Regards
rajesh

Create a shortcut for sqlplus and set the working directory. You can then use relative path and the files should go to the working directory.