OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the snapshot. |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the snapshot. |
SNAPSHOT_SITE |
VARCHAR2(128) |
NOT NULL |
Global name of the snapshot 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 NO, the snapshot is read only. |
REFRESH_METHOD |
VARCHAR2(11) |
|
Whether the snapshot uses rowids or primary key for fast refresh. |
SNAPSHOT_ID |
NUMBER(38) |
|
Identifier for the snapshot used by the master for fast refresh. |
VERSION |
VARCHAR2(17) |
|
Version of snapshot. |
QUERY_TXT |
LONG |
|
Original query of which this snapshot is an instantiation. |