Tag Archives: field in data file exceeds maximum length

[Solved] Oracle Import Error:field in data file exceeds maximum length

An error was reported when importing data with sqlldr today

” Record 1: Rejected – Error on table ks_ test, column khname.
Field in data file exceeds maximum length ”

After seeing this error, I thought it was caused by too small field value, and changed the original VARCHAR2 (1000) to VARCHAR2 (2000)

Found or not, still reported the above error, so suspected that sqlldr itself has some limitations

I checked it and found that it was

Refuse is defined in the original table_ Although reason is VARCHAR2 (1000)

However, the control file (CTL) is char by default

Therefore, when the column data length exceeds 255 (char type length), an error will be prompted

Solution:

The “refuse” in the CTL file_ Change “reason” to “refuse”_ Again char (2000) “OK

Note that it’s char type, not varchar type