Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?

From: Murty <>
Date: Tue, 21 Apr 2009 21:09:08 -0700 (PDT)
Message-ID: <>

Hi Phil,

>>why can't you have a DB link from B to A?

It is just that Server B is located in foreign country and our folks don't want the users/admins of that server to have "any kind" of access to Server A.
I tried to convice them, in vain, that DB Link creation is a one time step & the password will not be stored anywhere . I know it is a foolish restriction but I have to live with it.

Looks like MViews replicate the data based on "pull" mechanism (Target server pulls the changes from Source server). I just wonder why it is so difficult for
Oracle to implement "push" mechanism as well.

Any way, it seems like "Streams" is the ideal solution, even though it is somewhat complex to configure (&maintain) it for 50+ tables.

Thanks all for your help. Received on Tue Apr 21 2009 - 23:09:08 CDT

Original text of this message