Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_REGISTERED_SNAPSHOTS

Remote snapshots of local tables

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

Related:



Simon Sheppard
SS64.com