Database Utilities (MOSC)

MOSC Banner

ORA-12899 - Loading data into 11.2.0.3 database with AL32UTF8 character set

edited Dec 21, 2013 4:21AM in Database Utilities (MOSC) 15 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center