|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Owner of the materialized view
|
|
NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the materialized view
|
|
MVIEW_SITE
|
VARCHAR2(128)
|
NOT NULL
|
Global name of the materialized view site
|
|
CAN_USE_LOG
|
VARCHAR2(3)
|
|
YES if the materialized view can use a materialized view log, NO if the materialized view is too complex to use a log.
|
|
UPDATABLE
|
VARCHAR2(3)
|
|
(YES/NO) Indicates whether the materialized view is updatable. If set to NO, then the materialized view is read only.
|
|
REFRESH_METHOD
|
VARCHAR2(11)
|
|
Whether the materialized view uses primary key, rowids, or object identifiers for fast refresh
|
|
MVIEW_ID
|
NUMBER(38)
|
|
Identifier for the materialized view used by the masters for fast refresh
|
|
VERSION
|
VARCHAR2(26)
|
|
Oracle version of the materialized view
Note: Oracle9i materialized views show ORACLE 8 MATERIALIZED VIEW.
|
|
QUERY_TXT
|
LONG
|
|
Query that defines the materialized view
|
