DB links in Materialized View [message #75314] |
Thu, 30 January 2003 12:51 |
andy
Messages: 92 Registered: December 1999
|
Member |
|
|
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.
Thanks,
Andy
|
|
|
|