Field in data file exceeds maximum length
The default length of datatype CHAR is 255 in SQLLDR.
Instead of the following
-----------------
COL1 CHAR,
COL2 CHAR,
-----------------
Please change into
-----------------
COL1 CHAR(1000) NULLIF COL1=BLANKS,
COL2 CHAR(4000) NULLIF COL2=BLANKS,
-----------------
No comments:
Post a Comment