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

Similar Posts:

• SQL0668N Operation not allowed for reason code “3” on table “TEST”. SQLSTAT…
• Hive SemanticException:Expression not in GROUP BY
• Mysqldump error: tab (ErrCode:13-Permission denied) [How to Solve]
• [Solved] must appear in the GROUP BY clause or be used in an aggregate function
• [Solved] antD table Componet Error: warning.js?2149:7 Warning: [antdv: Each record in table should have a unique `key` prop,or set `rowKey` to an unique primary key.]
• You can’t specify target table for update….
• Unknown system variable ‘storage_engine’
• [Solved] Dell T30 error: Alert! Cover was previously removed.
• [Solved] Laravel attribute casting Error: Indirect modification of overloaded property
• [Hive on Tez] Input path does not exists error