Not Null Lob Column Failing With ORA-1400 For Replicat Using INSERTALLRECORDS
(Doc ID 2231128.1)
Last updated on FEBRUARY 09, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 to 22.214.171.124.0 [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:
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!