1 Reply Latest reply: Nov 4, 2011 2:28 PM by spajdy RSS

    MV log

    B_M_A
      Hi,

      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.

      Highly appreciated,TIA.

      Regards

      Basu
        • 1. Re: MV log
          spajdy
          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.