ALL_BASE_TABLE_MVIEWS

All materialized views with log(s)

in the database that the user can see

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