USER_BASE_TABLE_MVIEWS

All materialized views with log(s)

owned by the user in the database

Columns
   ___________________________
 
   OWNER
      Owner of the master table which changes are logged
   MASTER
      Name of the master table which changes are logged
   MVIEW_LAST_REFRESH_TIME
      One date per materialized view -- the date the materialized view was last refreshed
   MVIEW_ID
      Unique identifier of the materialized view


© Copyright SS64.com 1999-2014
Some rights reserved