Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Replicating triggers and procedures

Replicating triggers and procedures

From: Ralf Fernan <ralphfernan.nospam_at_yahoo.com>
Date: Thu, 13 Feb 2003 23:30:46 GMT
Message-ID: <GUV2a.35176$rq4.2667406@bgtnsc05-news.ops.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US