DBA_REGISTERED_MVIEWS

Remote materialized views of local tables

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,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


© Copyright SS64.com 1999-2014
Some rights reserved