Home Oracle Commands Oracle Data Dictionary
v$ Performance views

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

Related:


Simon Sheppard
 SS64.com