My Oracle Support Banner

OGG-01163 Bad column length (nnnn) due to Navarchar2(nnnnn) incorrectly capure (Doc ID 2459904.1)

Last updated on OCTOBER 23, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.
Replicate fails with

ERROR OGG-01163 Bad column length (NNNNN) specified for column XXXXXXX in table SCHEMA.TABLE, maximum allowable length is 4000

Symptoms

 Replicate abend with  OGG-01163 error

Trail file shows problem column length more than the desc of column

Column     4 (x0004), Len  6002 (x1772)         

Table desc shows column as

DETAIL_TEXT" NVARCHAR2(4000)

                             

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
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.