ALL_MVIEWS
describes all materialized views accessible to the current user.
DBA_MVIEWS
describes all materialized views in the database.
USER_MVIEWS
describes all materialized views owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Schema in which the materialized view was created |
MVIEW_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the materialized view |
CONTAINER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the container in which the materialized view's data is held. Normally this is the same as MVIEW_NAME . For materialized views created prior to Oracle8i, the Oracle Database attaches the 6-byte prefix SNAP$_ . If MVIEW_NAME has more than 19 bytes, then the Oracle Database truncates the name to 19 bytes and may add a 4-byte sequence number as a suffix to produce a nonambiguous CONTAINER_NAME . |
QUERY |
LONG |
Query that defines the materialized view | |
QUERY_LEN |
NUMBER(38) |
Length (in bytes) of the defining query | |
UPDATABLE |
VARCHAR2(1) |
Indicates whether the materialized view is updatable (Y ) or not (N ) |
|
UPDATE_LOG |
VARCHAR2(30) |
For updatable materialized views, the filename of the update log | |
MASTER_ROLLBACK_SEG |
VARCHAR2(30) |
Rollback segment for the master site or the master materialized view site | |
MASTER_LINK |
VARCHAR2(128) |
Database link for the master site or the master materialized view site | |
REWRITE_ENABLED |
VARCHAR2(1) |
Indicates whether rewrite is enabled (Y ) or not (N ) |
|
REWRITE_CAPABILITY |
VARCHAR2(9) |
Indicates whether the materialized view is eligible for rewrite, and if so, what rules must be followed:
|
|
REFRESH_MODE |
VARCHAR2(6) |
Refresh mode of the materialized view:
|
|
REFRESH_METHOD |
VARCHAR2(8) |
Default method used to refresh the materialized view (can be overridden through the API):
|
|
BUILD_MODE |
VARCHAR2(9) |
Indicates how the materialized view was populated during creation:
|
|
FAST_REFRESHABLE |
VARCHAR2(18) |
Indicates whether the materialized view is eligible for incremental (fast) refresh. The Oracle Database calculates this value statically, based on the materialized view definition query:
|
|
LAST_REFRESH_TYPE |
VARCHAR2(8) |
Method used for the most recent refresh:
|
|
LAST_REFRESH_DATE |
DATE |
Date on which the materialized view was most recently refreshed. Blank if not yet populated. | |
STALENESS |
VARCHAR2(19) |
Relationship between the contents of the materialized view and the contents of the materialized view's masters:
|
|
AFTER_FAST_REFRESH |
VARCHAR2(19) |
Specifies the staleness value that will occur if a fast refresh is applied to this materialized view. Its values are the same as for the STALENESS column, plus the value NA , which is used when fast refresh is not applicable to this materialized view. |
|
UNKNOWN_PREBUILT |
VARCHAR2(1) |
Indicates whether the materialized view is prebuilt (Y ) or not (N ) |
|
UNKNOWN_PLSQL_FUNC |
VARCHAR2(1) |
Indicates whether the materialized view contains PL/SQL functions (Y ) or not (N ) |
|
UNKNOWN_EXTERNAL_TABLE |
VARCHAR2(1) |
Indicates whether the materialized view contains external tables (Y ) or not (N ) |
|
UNKNOWN_CONSIDER_FRESH |
VARCHAR2(1) |
Indicates whether the materialized view is considered fresh (Y ) or not (N ) |
|
UNKNOWN_IMPORT |
VARCHAR2(1) |
Indicates whether the materialized view is imported (Y ) or not (N ) |
|
UNKNOWN_TRUSTED_FD |
VARCHAR2(1) |
Indicates whether the materialized view uses trusted constraints for refresh (Y ) or not (N ) |
|
COMPILE_STATE |
VARCHAR2(19) |
Validity of the materialized view with respect to the objects upon which it depends:
|
|
USE_NO_INDEX |
VARCHAR2(1) |
Indicates whether the materialized view was created using the USING NO INDEX clause (Y ) or the materialized view was created with the default index (N ). The USING NO INDEX clause suppresses the creation of the default index. |
|
STALE_SINCE |
DATE |
Time from when the materialized view became stale |
See Also:
Oracle Database Advanced Replication for more information on materialized views to support replication
Oracle Database Data Warehousing Guide for more information on materialized views to support data warehousing