How to configure path for SPOOL files?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to configure path for SPOOL files?

  1. #1
    Join Date
    May 2008
    Posts
    23

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    put the full path of where you want the file to go then

  3. #3
    Join Date
    May 2008
    Posts
    23

    How to configure path for SPOOL files?

    Is there no other way to set as default?

    Regards
    rajesh

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width