I am attempting to use GG to create an auditing table and am having some issues with the CLOB values returning null.
Basic structure is:
Table A has columns:
ID Number, Not Null
Comments CLOB, Not null,
COMMENTS_CONTACT NUMBER NOT NULL,
LAST_MODIFIED TIMESTAMP(6) NOT NULL
Auditing table is the same with some other metadata columns.
I am using INSERTALL command to track changes as they come in. The problem I am running in to is if a user does:
UPDATE TABLE_A
SET COMMENTS_CONTACT = "5" where ID = 1
I will receive a null constraint error on the insert in to my auditing table because Golden Gate is not picking up the CLOB (I am assuming it is not in the REDO log since the column is not updated).
Any ideas on this?
Currently on 11gr2 and latest patches of GoldenGate.