creating spool file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: creating spool file

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    creating spool file

    i want to create a spool file everytime i login to my SQL
    but it should not overwrite the previous file whenever i re-login to
    SQL session.

    is there any way to keep the previous spool file.

  2. #2
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Three ideas spring to mind:

    1) Use SPOOL filename APPEND to append to existing file
    2) use HOST command to move the file to a backup location
    3) Dynamically generate q unique filename via a SELECT statement and NEW_VALUE (maybe using a sequence?)

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    you can append sysdate to spool file and keep it better organised.

    check the link for many ways to do:

    http://www.dbasupport.com/forums/sea...?searchid=5456
    "What is past is PROLOGUE"

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