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