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

Oracle Error Message

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

Reason for the Error

The datafile has a physical record that is too long.

Solution

Use CONCATENATE or CONTINUEIF. Break up the physical records.