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.
For databases with the COMPATIBLE parameter set to 8.1.0 or higher, the name of the view is the same as the TABLE_NAME. For databases with the COMPATIBLE parameter set below 8.1.0, the name of the view is different than the TABLE_NAME. |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Table the in which the snapshot is stored. |
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. |