How to fix the Oracle error SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads

Reason for the Error SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads

The SKIP parameter was specified on the command line or in the OPTIONS statement, but the load was specified as continued with CONTINUE_LOAD. When a multiple-table direct load is interrupted, it is possible that a different number of records were loaded into each table. As a result, the number of records to skip must be specified for each table when continuing the load. In this case, the load is specified as continued with the CONTINUE_LOAD statement, and the number of records to skip is given in each INTO TABLE statement. See also messages 410 and 411 for more information.

How to fix the Error SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads ?

You can fix this error in Oracle by following the below steps

Check the log file to determine the appropriate number of records to skip for each table and specify this number in the INTO TABLE statement for each table in a continued load or with the command-line SKIP parameter in a standard load.