Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_REGISTERED_SNAPSHOTS

Remote snapshots of local tables that the user can see

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com