OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the snapshot |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the view used by users and applications for viewing the snapshot |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Table the snapshot is stored in. This table may have additional columns |
MASTER_VIEW |
VARCHAR2(30) |
|
View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8i and is set to NULL |
MASTER_OWNER |
VARCHAR2(30) |
|
Owner of the master table |
MASTER |
VARCHAR2(30) |
|
Name of the master table of which this snapshot is a copy |
MASTER_LINK |
VARCHAR2(128) |
|
Database link name to the master site |
CAN_USE_LOG |
VARCHAR2(3) |
|
YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log |
UPDATABLE |
VARCHAR2(3) |
|
Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to YES , the snapshot is read only |
REFRESH_METHOD |
VARCHAR2(11) |
|
Values used to drive a refresh of the snapshot (PRIMARY KEY /ROWID /COMPLEX ). If PRIMARY KEY , then the snapshot uses primary keys to drive a fast refresh. If ROWID , then it uses RowIDs to drive a fast refresh. If COMPLEX , then fast refreshes are not allowed and the snapshot can only perform complete refreshes |
LAST_REFRESH |
DATE |
|
Date and time at the master site of the last refresh |
ERROR |
NUMBER |
|
The number of failed automatic refreshes since last successful refresh |
FR_OPERATIONS |
VARCHAR2(10) |
|
Status of generated fast refresh operations: (REGENERATE , VALID ) |
CR_OPERATIONS |
VARCHAR2(10) |
|
Status of generated complete refresh operations: (REGENERATE , VALID ) |
TYPE |
VARCHAR2(8) |
|
Type of refresh for all automatic refreshes: COMPLETE , FAST , FORCE |
NEXT |
VARCHAR2(200) |
|
Date function used to compute next refresh dates |
START_WITH |
DATE |
|
Date function used to compute next refresh dates |
REFRESH_GROUP |
NUMBER |
|
All snapshots in a given refresh group get refreshed in the same transaction |
UPDATE_TRIG |
VARCHAR2(30) |
|
Obsolete. It is NULL for Oracle8i snapshots. Formerly, the name of the trigger that fills the UPDATE_LOG |
UPDATE_LOG |
VARCHAR2(30) |
|
The table that logs changes made to an updatable snapshots |
QUERY |
LONG |
|
Original query of which this snapshot is an instantiation |
MASTER_ROLLBACK_SEG |
VARCHAR2(30) |
|
Rollback segment to use at the master site |
STATUS |
VARCHAR2(7) |
|
The status of the contents of the snapshot |
REFRESH_MODE |
VARCHAR2(8) |
|
This indicates how and when the snapshot will be refreshed |
PREBUILT |
VARCHAR2(3) |
|
If YES, this snapshot uses a prebuilt table as the base table |