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) |
|
Indicates whether the materialized view can use a materialized view log (YES) or the materialized view is too complex to use a log (NO) |
UPDATABLE |
VARCHAR2(3) |
|
Indicates whether the materialized view is updatable (YES) or not and the materialized view is read only (NO) |
REFRESH_METHOD |
VARCHAR2(11) |
|
Indicates whether the materialized view uses primary key (PRIMARY KEY), rowids (ROWID), or object identifiers (OBJECT ID) 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 |
