ALL_REGISTERED_MVIEWS
describes all registered materialized views (registered at a master site or a master materialized view site) accessible to the current user.
DBA_REGISTERED_MVIEWS
describes all registered materialized views in the database.
USER_REGISTERED_MVIEWS
describes all registered materialized views owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
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 |
|
QUERY_TXT |
LONG |
Query that defines the materialized view |