creating spool file

[binoyshil]

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.

[hacketta1]

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?)

[dbasan]

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