My Oracle Support Banner

Not Null Lob Column Failing With ORA-1400 For Replicat Using INSERTALLRECORDS (Doc ID 2231128.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle GoldenGate - Version to [Release 11.2 to 12.2]
Information in this document applies to any platform.


Goldengate replicat abending with ORA-1400 for an INSERT against a table with LOB columns.

Replicat Discard file shows the originating record is an UPDATE:


Oracle GoldenGate Delivery for Oracle process started, group REP1 discard file opened: 2017-02-03 12:49:42.100570
Current time: 2017-02-03 12:49:42
Discarded record from action ABEND on error 1400

OCI Error ORA-01400: cannot insert NULL into ("SCOTT"."TEST"."COL_LOB_TEST1") (status = 1400), SQL <INSERT INTO "SCOTT"."TEST" ("COL1_KEY","COL2_DESC") VALUES (:a0,:a1)>
Aborting transaction on ./dirdat/e1 beginning at seqno 4 rba 1210426
error at seqno 4 rba 1210426
Problem replicating SCOTT.TEST to SCOTT.TEST
Mapping problem with compressed update record (target format)...



Using replicat INSERTALLRECORDS option.

Affected LOB column is NOT NULL on target.



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.