-
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
-
How to configure path for SPOOL files?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|