Home » Server Options » Replication » DB links in Materialized View
DB links in Materialized View [message #75314] Thu, 30 January 2003 12:51 Go to next message
Messages: 92
Registered: December 1999
Hello Everybody,

I could create materialized view and get it running. However I am curious to know the exact number of the database links required.

One Oracle doc prescribes following links. Apart for these links I have created one PUBLIC link too.

Can somebody explain me why the last link (#4) is required? Isn't the link #3 be doing all the refreshes (pulling data from master to view site?)

1. From the materialized view replication
administrator to the proxy materialized view
replication administrator.
2. From the propagator to the receiver.
3. From the refresher to the proxy refresher.
4. From the materialized view owner to the master site
or master materialized view site for refreshes.


Re: DB links in Materialized View [message #75329 is a reply to message #75314] Mon, 24 February 2003 04:37 Go to previous message
Guy Rassabi
Messages: 10
Registered: February 2003
Junior Member

Sec #4: because the refresh proc run on the view side which have to see the master table log via DBlink.

Previous Topic: Oracle 8i Synchronization
Next Topic: snapshot help!!
Goto Forum:

Current Time: Thu Nov 26 03:50:53 CST 2020