Snapshots the user can look at
Columns
___________________________
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 error returned last time an automatic refresh was attempted
FR_OPERATIONS
--
CR_OPERATIONS
--
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