Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 4, 2011 2:28 PM by
Oct 20, 2011 4:58 AM
We have implimented MV replication for multiple sites.We want to track the logs pending for particular mv site from
mv log tables since the same log table is used for multiple sites.
Can any one help how do we recognize for which site the logs are pending for.
This content has been marked as final.
Show 1 reply
Re: MV log
Nov 4, 2011 2:28 PM
in response to
in ALL_MVIEW_REFRESH_TIMES (DBA_MVIEW_REFRESH_TIMES) in column LAST_REFRESH is date when MV was refreshed. So the oldest date show you MV you are looking for.