Home » Server Options » Replication » Materialized view housekeeping servicename/dbid (10.2.0.4 / 11.2.0.3)
Materialized view housekeeping servicename/dbid [message #563479] Tue, 14 August 2012 05:05 Go to next message
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?
Re: Materialized view housekeeping servicename/dbid [message #563486 is a reply to message #563479] Tue, 14 August 2012 06:13 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
dba_registered_mviews
Re: Materialized view housekeeping servicename/dbid [message #563519 is a reply to message #563486] Tue, 14 August 2012 10:46 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Thanks, I'll check it out
Previous Topic: software required for migration with golden gate
Next Topic: Creation of Materialized view from oracle 10g - 8i (merged)
Goto Forum:
  


Current Time: Thu Apr 18 17:54:21 CDT 2024