Re: Replication Advice Needed

Charlotte,

Are the remote tables subject to DML? If not, you might want to consider materialized views, either with refresh on commit or frequent scheduled refreshes.

I don't much experience with Streams, although it does seem to be the future of Oracle replication. I do have experience with multimaster replication, which would work nicely, but might be more than you need.

--
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu

On 9/23/05, Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote:


>

> 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

> --

> http://www.freelists.org/webpage/oracle-l

>


--
http://www.freelists.org/webpage/oracle-l