How to fix the Oracle error SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number)?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number)

Reason for the Error SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number)

The datafile has a physical record that is too long.

How to fix the Error SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number) ?

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

Use CONCATENATE or CONTINUEIF. Break up the physical records.