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: Oracle Database materialized views show ORACLE 8 MATERIALIZED VIEW. |
QUERY_TXT |
LONG |
|
Query that defines the materialized view |
