Options to be specified in SQL control files which call multiple scripts
SET DEFINE OFF
- if there are special characters to be inserted
SET ECHO ON -
to get SQL statements executed along with their execution results.
SPOOL <path\file_name>
- file name for spooling output. Make sure the user which runs the script has
write permission in the directory where spool file will be written, else after
scripts are complete, you will find yourself scratching your head for that
missing spool file : )
SET TIMING ON
- to get timings of various sql statements executed.
SET TERMOUT ON
SET TIME ON –
to get time on command prompt. Quite useful when master control file runs many
many queries and takes hours/minutes to run.
0 Comments:
Post a Comment
<< Home