OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the materialized view |
MVIEW_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the materialized view |
MVIEW_TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the container table (see next column) |
CONTAINER_NAME |
VARCHAR2(30) |
|
Name of the internal container in which the materialized view data is held. Normally this is the same as MVIEW_NAME . For materialized views created in releases before 8.1 (or under pre-8.1 compatibility mode), Oracle attaches the 6-byte prefix SNAP$_. If MVIEW_NAME has more than 19 bytes, Oracle truncates the name to 19 bytes and adds a 4-byte sequence number as a suffix to produce a nonambiguous CONTAINER_NAME . |
LAST_REFRESH_SCN |
NUMBER |
|
System change number (SCN) of the last refresh operation |
LAST_REFRESH_DATE |
DATE |
|
SYSDATE of the last refresh |
REFRESH_METHOD |
VARCHAR2(8) |
|
Default refresh method: FORCE , FAST , COMPLETE , or NONE |
SUMMARY |
VARCHAR2(1) |
|
Whether this materialized view includes a GROUP BY clause or aggregation (Y | N ) |
FULLREFRESHTIM |
NUMBER |
|
Approximate refresh time, in seconds, for full refresh (defined only when SUMMARY = Y) |
INCREFRESHTIM |
NUMBER |
|
Approximate refresh time, in seconds, for fast refresh (defined only when SUMMARY = Y) |
CONTAINS_VIEWS |
VARCHAR2(1) |
|
Whether this materialized view contains a view in its definition (Y | N) |
UNUSABLE |
VARCHAR2(1) |
|
Whether this materialized view is UNUSABLE (inconsistent data) (Y | N). A materialized view can be UNUSABLE if a system failure occurs during a full refresh. |
RESTRICTED_SYNTAX |
VARCHAR2(1) |
|
Whether this materialized view had a restriction in its defining query that limits the use of query rewrite (Y | N). More complete information is provided by the REWRITE_CAPABILITY column of the ALL_ , DBA_ , and USER_MVIEWS views. |
INC_REFRESHABLE |
VARCHAR2(1) |
|
Whether this materialized view can be fast refreshed (Y | N) |
KNOWN_STALE |
VARCHAR2(1) |
|
Whether the data contained in the materialized view is known to be inconsistent with the master table data because that has been updated since the last successful refresh (Y | N) |
INVALID |
VARCHAR2(1) |
|
Whether this materialized view is in an invalid state (inconsistent metadata) (Y | N) |
REWRITE_ENABLED |
VARCHAR2(1) |
|
Whether this materialized view is currently enabled for query rewrite (Y | N) |
QUERY_LEN |
NUMBER |
NOT NULL |
The length (in bytes) of the query field |
QUERY |
LONG |
NOT NULL |
SELECT expression of the materialized view definition |
REVISION |
NUMBER |
|
Reserved for internal use |