ALL_SNAPSHOTS

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

Related Commands:

 DBA_RGROUP
 DBA_RCHILD 
 DBA_REFRESH