Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_REGISTERED_SNAPSHOTS

Remote snapshots of local tables currently using logs owned by the user

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com