Not Null Lob Column Failing With ORA-1400 For Replicat Using INSERTALLRECORDS
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.
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