Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?
From: Phil H <phil_herring_at_yahoo.com.au>
Date: Tue, 21 Apr 2009 22:54:55 -0700 (PDT)
Message-ID: <6d03d84e-4738-4332-85cc-1a70da75a783_at_l16g2000pra.googlegroups.com>
On Apr 22, 2:09 pm, Murty <m_ad..._at_hotmail.com> wrote:
Date: Tue, 21 Apr 2009 22:54:55 -0700 (PDT)
Message-ID: <6d03d84e-4738-4332-85cc-1a70da75a783_at_l16g2000pra.googlegroups.com>
On Apr 22, 2:09 pm, Murty <m_ad..._at_hotmail.com> 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