Oracle sqlldr data import error Field in data file exceeds maximum length

Oracle sqlldr data import error Field in data file exceeds maximum length solves the problem of Field in data file exceeds maximum length error when using oracle sqlldr for data import: www.2cto.com indicates that the data field is indeed longer than the database field. In this case, you need to adjust the length of the database field, or reduce the length of the field. The second is because of the problem of the fields to be imported into the database (Chinese). This problem is solved by adding the character type representation in the control file. For example, the red part of the Java code www.2cto.com is the part where the Field in data file exceeds maximum lengt error is reported in the database. Add char (n) according to the actual length of the Field ), for example, fields such as COMPLAINT_CONTENT, handle_advice, and backfeed_advice (char rather than varchar2) are specified according to the actual length, and the data can be imported to the database normally.