DBA_MVIEW_REFRESH_TIMES

All fast refreshable materialized views and their last refresh times for each master table

Columns
   ___________________________
 
   OWNER
      Owner of the materialized view
   NAME
      The view used by users and applications for viewing the MV
   MASTER_OWNER
      Owner of the master table
   MASTER
      Name of the master table
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh

Related:


© Copyright SS64.com 1999-2014
Some rights reserved