GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger replica

Annamalai ADec 7 2011 — edited Dec 8 2011

Hi Experts,

Regarding trigger replication between source and Target with Bi directional mechanism, I'm using sqlexec to call the disable and enable triggers when start the replication process with help of Sqlexec method, Before MAP the replicat will disable the trigger and once mapped/replicated again the triggers will be enabled , My doubt is , When i disabled the triggers ,if any transaction happend in related particular disabled trigger what will happend? can we go with this approach or any other method is available. I can't use suppresstrigger option since my db is not 10.2.0.5 and higher. please guide me on this scenario.

SQLEXEC "call disable_triggers ()"
MAP SRC.IN_PAYMENTS, TARGET TGT.IN_PAYMENTS;
SQLEXEC "call enable_triggers ()"

Thanks,
ASP

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2012

Added on Dec 7 2011

#goldengate

2 comments

219 views