How to configure path for SPOOL files?

[rajeshbalusu]

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

[davey23uk]

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

[rajeshbalusu]

Is there no other way to set as default?

Regards
rajesh

[gandolf989]

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.