GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Integrated Replicat

edited Jul 27, 2016 10:24PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

Hi

I have a couple of questions regarding Integrated Replicat.

1) We have configured an Integrated Replicat. Whenever an ORA error is encountered by Replicat, it retries the transaction in Direct Mode. Is there anyway this can be turned off and avoid retrying in Direct Mode? 

2) Even though we have SUPPRESSTRIGGERS DBOPTION in the Replicat Parameter File, we noticed some of the triggers have fired.  A trigger on a table inserts rows into a tracking table.  When rows were inserted into the table by replicat, the tracking table also was inserted into.  So, for the 3 records inserted into the table with the trigger, the tracking table had 6 records - one that came from source, 1 from the trigger caused by the insert operation by replicat.

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