Go with Streams. It works quite well. It is also faster than AR, and easier to setup. For initial setup check Sanjay Mishra's http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.html Ranko. On 9/23/05, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote: > > Charlotte, > If there is no DML at remote database use MM and your life is very easy. > If there will be DML at remote you have choice of using multi master > AR or streams. Choose one where you are more confident. If I have to > learn both, it would be streams. > > The Streams architecture is lot more flexible than Oracle > Replication's. This leads me to suspect that Oracle will be pushing > Streams over Replication in subsequent releases, so I would expect new > features in Streams, like DDL changes, that aren't in Oracle > Replication. Realistically, though, I don't expect any serious > movement away from Replication for at least a few releases, so I > wouldn't tend to be overly concerned on this front. > > Streams replication is log based. Capture process catpures DDL and DML > changes. So no additional overhead on user transactions. (Mutil maser > uses internal trigger and this will get fired for each DML. There's a > slight overhead on user transactions) > > Oracle Replication is a significantly more mature product-- it is > quite usable with older databases. Oracle Streams is a much newer > technology and is only usable among different 9i or higher databases. > Most competent Oracle developers and DBA's are familiar with Oracle > Replication, while many fewer have any real experience with Streams. > > Regards > Sandeep > > > > On 9/23/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote: > > > > > > Charlotte, > > > > Very quickly... > > > > I would use Multi Master Advanced Replication for this. > > Multi Master Replication is perfect for "small-ish / low-volume tables" > > with little dependencies where data changes happen infrequently and > > on one database MOST/ALL of the time > > > > I would stay far away from "synchronous" Replication...just run > > the "push" and "purge" jobs say every five minutes...unless you > > really need real time changes at both ends. > > > > Having sad all of this I have no real experience with Streams and > > maybe some here will say that it is just as well. > > > > If you go with Multi Master Replication I can send you some personal > notes. > > > > Be forewarned that Multi Master Advanced Replication is not with > administration head aches as is *ANY* transaction based data synchronization > option/tool. > > > > > > hth > > > > Chris Marquez > > Oracle DBA > > > > > > -----Original Message----- > > From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Charlotte Hammond > > Sent: Fri 9/23/2005 10:55 AM > > To: ORACLE-L > > Subject: Replication Advice Needed > > > > Hi All, > > > > We need to keep 5 (small-ish / low-volume) tables on a > > remote database in sync with those in the local > > database. We want synchronous updates of the remote > > tables when the network allows but we also want to > > apply queued transactions after recovery from a > > network failure such that no transactions are ever > > lost (assuming the local database to be "unbreakable" > > :-) > > > > I'm thinking of advanced replication or streams but > > unfortunately I don't have any experience in either. > > I know this is going to require lots of reading and > > experimenting but I was hoping to short-circuit this > > by at least focusing on the right technology to start > > with!: what sounds like the best fit - AR or streams? > > (This is on 10g) > > > > Thank you all in advance for any help > > > > Charlotte > > > > > > > > > > > > __________________________________ > > Yahoo! Mail - PC Magazine Editors' Choice 2005 > > http://mail.yahoo.com > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > > -----Original Message----- > > From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Charlotte Hammond > > Sent: Fri 9/23/2005 10:55 AM > > To: ORACLE-L > > Subject: Replication Advice Needed > > > > Hi All, > > > > We need to keep 5 (small-ish / low-volume) tables on a > > remote database in sync with those in the local > > database. We want synchronous updates of the remote > > tables when the network allows but we also want to > > apply queued transactions after recovery from a > > network failure such that no transactions are ever > > lost (assuming the local database to be "unbreakable" > > :-) > > > > I'm thinking of advanced replication or streams but > > unfortunately I don't have any experience in either. > > I know this is going to require lots of reading and > > experimenting but I was hoping to short-circuit this > > by at least focusing on the right technology to start > > with!: what sounds like the best fit - AR or streams? > > (This is on 10g) > > > > Thank you all in advance for any help > > > > Charlotte > > > > > > > > > > > > __________________________________ > > Yahoo! Mail - PC Magazine Editors' Choice 2005 > > http://mail.yahoo.com > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > -- > //www.freelists.org/webpage/oracle-l >