Default: There is no default.
Purpose
The SILENT parameter suppresses some of the content that is written to the screen during a SQL*Loader operation.
Syntax and Description
SILENT=[HEADER | FEEDBACK | ERRORS | DISCARDS | PARTITIONS | ALL]
Use the appropriate values to suppress one or more of the following (if more than one option is specified, they must be separated by commas):
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" messages and the status messages for the load 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.
Example
For example, you can suppress the header and feedback messages that normally appear on the screen with the following command-line argument:
SILENT=HEADER, FEEDBACK