Home » Server Options » Replication » Replicate one table in two materialized views at same time (Oracle 10.2.0.3 - Redhat Linux)
Replicate one table in two materialized views at same time [message #358425] Tue, 11 November 2008 04:42 Go to next message
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

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 Go to previous message
babuknb
Messages: 1736
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
Previous Topic: create a Materialized View without having any data in it (merged)
Next Topic: Replicating one repobject in multiple sites
Goto Forum:
  


Current Time: Thu Mar 28 11:17:09 CDT 2024