Materialized view housekeeping servicename/dbid [message #563479] |
Tue, 14 August 2012 05:05 |
|
Flyby
Messages: 188 Registered: March 2011 Location: Belgium
|
Senior Member |
|
|
Hello,
How does an oracle materialized view log host keep track of pulling oracle materialized view clients?
By global service name or databaseid?
Case:
Oracle database host A hosting table X with corresponding materialized view log MLOG$_X
Oracle database host B creates a materialized view on A.X using fast refresh (pull)
Oracle database host C creates a materialized view on A.X using fast refresh (pull)
How does Oracle database host A keeps track of host B and C in order to clean up MLOG$_X?
|
|
|
|
|