My Oracle Support Banner

Integrated Replicat Runs Slower With ORA-1840 Warning For Default On NULL column (Doc ID 2369232.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


Customer referred earlier Doc ID 2209092.1 and one off Patch 21820934 was applied. Still we were seeing the warning and replicat slowness for the column which had Default Value for a NULL Column with NOT NULL constraint on it.


2017-10-23 13:23:55  WARNING OGG-02544  Unhandled error (ORA-01840: input value not long enough for date format) while processing the record at SEQNO 1672, RBA 232201766 in Integrated mode. REPLICAT will retry in Direct mode.

Classic Replicat runs fine with same configuration.



 Replicating a table having Default on NULL column


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

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