My Oracle Support Banner

OGG REPLICAT abend Error ORA-12899: value too large for column (Doc ID 1927858.1)

Last updated on JANUARY 19, 2020

Applies to:

Oracle GoldenGate - Version 11.2.1.0.20 and later
Information in this document applies to any platform.

Symptoms

v11.2.1 REPLICAT is abending with:

2014-09-16 22:05:59 WARNING OGG-01154 SQL error 12899 mapping OWNER.TABLE_NAME to OWNER.TABLE_NAME OCI Error ORA-12899: value too large for column "OWNER"."TABLE_NAME"."COLUMN_NAME" (actual: 45, maximum: 30) (status = 12899). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "OWNER"."TABLE_NAME"

The discard file shows the same error and that column displays Raw Data:

COLUMN_NAME = <Raw Data>
000000: e4 b8 80 e6 9d a1 30 2e 32 e5 85 83 ef bc 88 e5 |......0.2.......|
000010: af 84 e4 bb b6 ef bc 89

The table create DDL on the source and target tables show the DDL for the column COLUMN_NAME is identical: VARCHAR2(30).

A dump of the row on the source shows Japanese

SELECT COLUMN_NAME, dump(COLUMN_NAME)
FROM OWNER.TABLE_NAME
WHERE EMPLOYMENT_HST_ID=9108574;

COLUMN_NAME
------------------------------
DUMP(COLUMN_NAME)
--------------------------------------------------------------------------------
一条0.2元(寄件)
Typ=1 Len=24: 228,184,128,230,157,161,48,46,50,229,133,131,239,188,136,229,175,1
32,228,187,182,239,188,137

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.