Replicat Abended Due to Oracle Error ORA-12899

(Doc ID 959912.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 9.5.1.70 and later
Information in this document applies to any platform.
Goldengate Replicat version 9.x and above

Checked for relevance on 04DEC-2012


Symptoms

Replicat Abends.

The report file contains:

GGS WARNING 218 SQL error 12899 mapping JOHN.TEST to SCOTT.TEST

GGS ERROR 218 Error mapping  JOHN.TEST to SCOTT.TEST

The Discard file contains:

ORA-12899: value too large for column "SCOTT"."TEST"."LASTNAME" (actual: 259, maximum: 255),

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms