OraFAQ Forum: Replication » Replicate one table in two materialized views at same time

Home » Server Options » Replication » Replicate one table in two materialized views at same time (Oracle 10.2.0.3 - Redhat Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replicate one table in two materialized views at same time [message #358425]

Tue, 11 November 2008 04:42

mafc73
Messages: 38
Registered: November 2006

Member

Hi,

I have a table in one database and I want to replicate it in another two databases with materialized views. The refresh may be fast. Is this possible?.

Thanks

Report message to a moderator

Re: Replicate one table in two materialized views at same time [message #358815 is a reply to message #358425]

Wed, 12 November 2008 10:06

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

why not??

In Master Site; Create materialized view log & In Materialized view site as per your business logic create materialized view with refresh type fast/force/complete.

Babu

Report message to a moderator

Previous Topic:	create a Materialized View without having any data in it (merged)
Next Topic:	Replicating one repobject in multiple sites

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 15:43:09 CDT 2023