DBA_REGISTERED_SNAPSHOTS

Remote snapshots of local tables

Columns
   ___________________________
 
   NAME
      The name of the snapshot
   QUERY_TXT
      Query defining the snapshot
   OWNER
      Owner of the snapshot
   SNAPSHOT_ID
      Identifier for the snapshot used by the master for fast refresh
   SNAPSHOT_SITE
      Global name of the snapshot site
   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 rowids or primary key for fast refresh
   VERSION
      Version of snapshot

Related Commands:

Simon Sheppard
SS64.com