The Oracle Spool command is a nice little feature that allows you to record what goes on in your sqlplus session on the fly. Enabling it is simple and can be a very good logging/debugging tool.
To record your sqlplus session commands, simply type:
SQL> spool /tmp/myfile.txt
where myfile.txt is the name you want to give to your log file.
The file will not appear or be usable until you turn off spooling:
SQL> spool off
Voila!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment