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