Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Replicating triggers and procedures
Is it necessary to include the triggers or stored procedures in the
replication group, if the data structures (tables) they affect are in that
replication group?
So, in a (multimaster) replication environment, if the DB application executes a trigger or procedure which results in data modifications on one master site, will Oracle propogate these changes to the other master sites, if 1) the affected tables are included in the replication group, but the affecting triggers and procedures are not; or, 2) the affected tables, and affecting triggers and procedures are included in the replication group. Received on Thu Feb 13 2003 - 17:30:46 CST