GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Is there a way to force serialization of transaction replication in GoldenGate?

edited Nov 15, 2018 1:40PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Using  GoldenGate 12.1.2.1.0  to replicate between 2 sites.  My problem is: I have 1 long running data import job (let's say 30 minutes, 20 tables). At the conclusion of the job, the user initiates a second job that is dependent on that data.  The 2nd job inserts a row into a different table.  A trigger on that table kicks off job that reads all of the imported data.   What appears to be happening is the INSERT transaction (2nd job), replicates to the remote site and fires the trigger (desired action) before the replication of the 1st jobs import has completed.

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