USER_MVIEWS

All materialized views in the database
Columns
   ___________________________
 
   MASTER_LINK
      Name of the database link to the master site
   COMPILE_STATE
      Indicates the validity of the MV meta-data
   CONTAINER_NAME
      Name of the materialized view container table
   QUERY
      The defining query that the materialized view instantiates
   OWNER
      Owner of the materialized view
   QUERY_LEN
      The number of bytes in the defining query (based on the server character set
   UPDATABLE
      Indicates whether the materialized view can be updated
   MASTER_ROLLBACK_SEG
      Name of the rollback segment to use at the master site
   MVIEW_NAME
      Name of the materialized view
   REWRITE_ENABLED
      Indicates whether rewrite is enabled for the materialized view
   REWRITE_CAPABILITY
      Indicates the kind of rewrite that is enabled
   REFRESH_MODE
      Indicates how and when the materialized view will be refreshed
   REFRESH_METHOD
      The default refresh method for the materialized view (complete, fast, ...)
   BUILD_MODE
      How and when to initially build (load) the materialized view container
   FAST_REFRESHABLE
      Indicates the kinds of operations that can be fast refreshed for the MV
   LAST_REFRESH_TYPE
      Indicates the kind of refresh that was last performed on the MV
   LAST_REFRESH_DATE
      The date that the materialized view was last refreshed
   STALENESS
      Indicates the staleness state of the materialized view (fresh, stale, ...)
   AFTER_FAST_REFRESH
      Indicates the staleness state the MV will have after a fast refresh is done
   UPDATE_LOG
      Name of the table that logs changes to an updatable materialized view
Related Commands:
Simon Sheppard
SS64.com