Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_REGISTERED_MVIEWS

Remote materialized views of local tables that the user can see 

Columns
   ___________________________
 
   OWNER
      Owner of the materialized view
   NAME
      The name of the materialized view
   MVIEW_SITE
      Global name of the materialized view site
   CAN_USE_LOG
      If NO,this materialized view is complex and cannot fast refresh
   UPDATABLE
      If NO,the materialized view is read only
   REFRESH_METHOD
      Whether the materialized view uses rowid or primary key or object id for fast refresh
   MVIEW_ID
      Identifier for the materialized view used by the master for fast refresh
   VERSION
      Version of materialized view
   QUERY_TXT
      Query defining the materialized view

Related:


Simon Sheppard
 SS64.com