Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

SQL*Loader-00301

string for TERMINATED BY or ENCLOSED BY clause is longer than number bytes

Cause

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.


Action

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