ORA-12899 - Loading data into 11.2.0.3 database with AL32UTF8 character set
Hi,
we have a 11.2.0.3 Database with database characterset of AL32UTF8
We are trying to load data in the database but on some of the tables we are getting "ORA-12899: value too large for column errors"
Here is an example
Record 17312: Rejected - Error on table EDI_DESC.
ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "EDI"."EDI_DESC"."COMMERCIAL_DESCRIPTION" (actual: 71, maximum: 70)
This is the data we’re trying to load:
~GBBDUKPLY ~|~932000940 ~|+20120608|+00010|+00001|~175 cm² Cell Culture Flask
The column is defined as --> COMMERCIAL_DESCRIPTION" CHAR(70) DEFAULT ' ' NOT NULL
Can someone please let us know how to address this? Please note that we cannot use VARCHAR2 due to
0