Controlling the Bulk Loader Maximum Error Count

The max_errors parameter controls the number of data errors allowed before the bulk loader’s operations are canceled. The default value for max_errors is 10, which means that the bulk loader aborts after encountering 10 bad records. These bad records are written to the discard file and information about the error is written into the bulk loader log file.

When several bulk loader errors occur, increasing the maximum error count allows you to gather all the errors in one run rather than finding 10 errors and then having to start over again. For more details, see max_errors in [Bulk_Loader].