How to fix the Oracle error SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

Reason for the Error SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

The the record format of the named LOBFILE or SDF file is incorrect.

How to fix the Error SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string ?

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

Fix the record formatting problems in the file.