How to fix the Oracle error SQL*Loader-00650: incomplete lob data written for column string, row number, table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00650: incomplete lob data written for column string, row number, table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00650: incomplete lob data written for column string, row number, table string

Reason for the Error SQL*Loader-00650: incomplete lob data written for column string, row number, table string

Encountered errors (e.g. parsing errors in LOBFILE) while loading LOBs using direct path. The row will remain in the table and its LOB column may not be complete. Loading of other records will continue.

How to fix the Error SQL*Loader-00650: incomplete lob data written for column string, row number, table string ?

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

Correct the data file (see accompanying messages) and reload.