USER_SNAPSHOTS

Columns
   ___________________________
 
   STATUS
      The status of the contents of the snapshot
   UPDATE_LOG
      The table which logs changes made to an updatable snapshots
   REFRESH_MODE
      This indicates how and when the snapshot will be refreshed
   MASTER_ROLLBACK_SEG
      Rollback segment to use at the master site
   QUERY
      The original query that this snapshot is an instantiation of
   MASTER_LINK
      Database link name to the master site
   OWNER
      Owner of the snapshot
   NAME
      The view used by users and applications for viewing the snapshot
   TABLE_NAME
      Table the snapshot is stored in -- has an extra column for the master rowid
   MASTER_VIEW
      View of the master table, owned by the snapshot owner, used for refreshes
   PREBUILT
      If YES, this snapshot uses a prebuilt table as the base table
   MASTER
      Name of the master table that this snapshot is a copy of
   UPDATE_TRIG
      The name of the trigger which fills the UPDATE_LOG
   CAN_USE_LOG
      If NO, this snapshot is complex and will never use a log
   UPDATABLE
      If NO, the snapshot is read only.  Look up REPLICATION
   REFRESH_METHOD
      The values used to drive a fast refresh of the snapshot
   START_WITH
      The date function used to compute next refresh dates
   MASTER_OWNER
      Owner of the master table
   REFRESH_GROUP
      All snapshots in a given refresh group get refreshed in the same transaction
   LAST_REFRESH
      SYSDATE from the master site at the time of the last refresh
   NEXT
      The date function used to compute next refresh dates
   TYPE
      The type of refresh (complete,fast,force) for all automatic refreshes
   CR_OPERATIONS
   FR_OPERATIONS
   ERROR
      The error returned last time an automatic refresh was attempted

Related Commands:

 DBA_RGROUP
 DBA_RCHILD 
 DBA_REFRESH