GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Need help capturing delete on a child table with cascade-delete fk constraints

edited Dec 26, 2013 5:59AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
I am setting up goldengate for auditing, capturing only the transaction type (INSERT,UPDATE,DELETE) and PK value of the table where the DML happen, and inserting the information to a table.

4 of the tables are child tables to 1 master table.  What I noticed happening is that the extract and replicate process is capturing the DELETE txn on the master including the PK value but on the CHILD tables the DELETE txn is being captured but not the PK value of the child tables. 

Is there a way to force the capture the PK value of the child tables?

--extract

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center