You can use the keywordsilent
, which is available in theoptions clause. You can set thefollowing thingsto be silent:
HEADER – Suppresses the SQL*Loader header messages that normally appear on the screen. Header messages still appear in the log file.
FEEDBACK – Suppresses the “commit point reached” feedback messages that normally appear on the screen.
ERRORS – Suppresses the data error messages in the log file that occur when a record generates an Oracle error that causes it to be
written to the bad file. A count of rejected records still appears.DISCARDS – Suppresses the messages in the log file for each record written to the discard file.
PARTITIONS – Disables writing the per-partition statistics to the log file during a direct load of a partitioned table.
ALL – Implements all of the suppression values: HEADER, FEEDBACK, ERRORS, DISCARDS, and PARTITIONS.
You would want to suppressfeedback
.
You can either use on the command line, for instance:
sqlldr schema/pw@db silent=(feedback, header)
On in the options clause of the control file, for instance:
options (bindsize=100000, silent=(feedback, errors) )