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

Similar Posts:

• used in key specification without a key length
• [Solved] The length of the data truncation done by springboothinesdata for the column.
• Solution of data truncated for column ‘xxx’ in MySQL
• In Oracle, an error is reported: ora-00904
• Error in modifying data element data type [How to Solve]
• MySQL: invisible empty symbol char (9) char (10) char (13)
• [Solved] Oracle :value too large for column “SCHEMA”.”TABLE”.”COLUMN” (actual: 519, maximum: 500)
• Error in importing excel file from SQL Server
• [Solved] MySQL Add New Field Error: ERROR 1118 — Row size too large. The maximum row size for the used table type
• [Solved] Exporting sqoop from hive to MYSQL error: failed with state FAILED due to: Task failed