ALL_SNAPSHOT

ALL_SNAPSHOT_LOGS

All snapshot logs in the database that the user can see

Columns
   ___________________________
 
   SNAPSHOT_ID
      Unique identifier of the snapshot
   LOG_OWNER
      Owner of the snapshot log
   MASTER
      Name of the master table which chnages are logged
   LOG_TABLE
      Log table; with  rowids and timestamps of rows which changed in the master
   LOG_TRIGGER
      An after-row trigger on the master which inserts rows into the log
   ROWIDS
      If YES, the snapshot log records rowid information
   CURRENT_SNAPSHOTS
      One date per snapshot -- the date the snapshot of the master last refreshed
   FILTER_COLUMNS
      If YES, the snapshot log records filter column information
   PRIMARY_KEY
      If YES, the snapshot log records primary key information

Related Commands:

Simon Sheppard
SS64.com