ALL_MVIEW_REFRESH_TIMES

Materialized views and their last refresh times for each master table that the user can look at

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


© Copyright SS64.com 1999-2014
Some rights reserved