How to fix the Oracle error SQL*Loader-00411: Only a direct path load may be continued?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00411: Only a direct path load may be continued with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00411: Only a direct path load may be continued

Reason for the Error SQL*Loader-00411: Only a direct path load may be continued

The load is specified with CONTINUE_LOAD, but DIRECT=FALSE. CONTINUE_LOAD is only possible for a direct path load and is only necessary for a multiple-table, direct path load when a different number of records have been loaded into each table. See also messages 409 and 410 for more information.

How to fix the Error SQL*Loader-00411: Only a direct path load may be continued ?

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

If CONTINUE_LOAD is necessary, specify a direct load and put the number of records to skip in each INTO TABLE statement. Otherwise, use the command line or OPTIONS clause to specify the number of records to skip and use LOAD DATA instead of CONTINUE_LOAD.