Oracle Error SQL*Loader-00301: string for TERMINATED BY or ENCLOSED BY clause is longer than number bytes

Oracle Error Message

SQL*Loader-00301: string for TERMINATED BY or ENCLOSED BY clause is longer than number bytes

Reason for the Error

The size of a string literal is longer than the maximum number of bytes allowed for an ENCLOSED BY or TERMINATED BY string. This error can also occur if the string needs to be converted to the character set of the data file and the resulting string is too long.

Solution

Use shorter strings for the TERMINATED BY and ENCLOSED BY clauses.