DBA_SNAPSHOTS
All snapshots in the databaseColumns
___________________________
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
MASTER_OWNER
Owner of the master table
MASTER
Name of the master table that this snapshot is a copy of
MASTER_LINK
Database link name to the master site
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
LAST_REFRESH
SYSDATE from the master site at the time of the last refresh
ERROR
The number of failed automatic refreshes since last successful refresh
FR_OPERATIONS
If REGENERATE,then the fast refresh operations have not been generated
CR_OPERATIONS
If REGENERATE,then the complete refresh operations have not been generated
TYPE
The type of refresh (complete,fast,force) for all automatic refreshes
NEXT
The date function used to compute next refresh dates
START_WITH
The date function used to compute next refresh dates
REFRESH_GROUP
All snapshots in a given refresh group get refreshed in the same transaction
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
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:
DBA_RGROUP DBA_RCHILD DBA_REFRESH