-
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.
-
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?)
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|