Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

triggers fired by replication

Status
Not open for further replies.

glager

Technical User
Dec 17, 2002
3
US
Can I put a trigger on a table that would be fired when advanced replication updates the table?
 
Yes, but since you can't control the order in which triggers fire (other than BEFORE and AFTER) make sure you don't have 2 or more BEFORE triggers.

The default behavior in Oracle 734 and 816 was for Oracle to fire any trigger on a table whether replicated or not. If you don't want the trigger to fire there is a predicate you must put in your trigger code. That's explained fully in your documentation.

-Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top