| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_REGISTERED_MVIEWS describes all registered materialized views (registered at a master site or a master materialized view site) accessible to the current user.
Related Views
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 |
