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

From: Phil H <>
Date: Tue, 21 Apr 2009 22:54:55 -0700 (PDT)
Message-ID: <>

On Apr 22, 2:09 pm, Murty <> wrote:

> 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.

They did this. It's called Streams. Mind you, mviews are usually the way to go for read-only copies.

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

I suggest you read up on the limitations of Streams first, and make sure it will do what you want.

  • Phil
Received on Wed Apr 22 2009 - 00:54:55 CDT

Original text of this message