All,

I would like to know if we can set up similar to Materized view
between

Source -->Oracle RDMS

replicating site --> MS SQL Server


Looks DB link can be created between MS SQL server to Oracle server


regards

On Tue, 17 May 2011 22:21:15 -0700, Kaparwan wrote:

Golden Gate can do that.



--
http://mgogala.byethost5.com

On May 18, 10:54*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:


Indeed. It is an amazing product!

On May 19, 2:26*am, Noons <wizofo... (AT) gmail (DOT) com> wrote:
thanks Mladen and Noons

if we would need just 3 tables to replicate ( there are 1000 tables in
total) to non oracle target site
in that case would it be Ok to go ahead with Golden Gate?

Kaparwan wrote,on my timestamp of 19/05/2011 1:54 PM:

Yup. You can add filters to the GG setup so that it only does the tables you
want. Or at least that's what the guy doing the GG demo showed us!