ALL_MVIEW_ANALYSIS
describes the materialized views accessible to the current user. It provides additional information for analysis by applications. Minimal information is displayed for materialized views that do not support query rewrite (such as materialized views with remote master tables or nondeterministic functions).
Related Views
DBA_MVIEW_ANALYSIS
describes all such materialized views in the database.
USER_MVIEW_ANALYSIS
describes all such materialized views owned by the current user.
Note:
All of the information in these views is also displayed in ALL_MVIEWS
and its related views. Oracle recommends that you refer to ALL_MVIEWS
for this information instead of these views.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
Owner of the container table (see next column) |
|
|
Name of the internal container in which the materialized view data is held. Normally this is the same as |
|
|
|
System change number (SCN) of the last refresh operation |
|
|
|
|
|
|
|
Default refresh method:
|
|
|
|
Indicates whether this materialized view includes a |
|
|
|
Approximate refresh time, in seconds, for full refresh |
|
|
|
Approximate refresh time, in seconds, for fast refresh |
|
|
|
Indicates whether this materialized view contains a view in its definition ( |
|
|
|
Indicates whether this materialized view is |
|
|
|
Indicates whether this materialized view had a restriction in its defining query that limits the use of query rewrite ( |
|
|
|
Indicates whether this materialized view can be fast refreshed ( |
|
|
|
Indicates 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 ( |
|
|
|
Indicates whether this materialized view is in an invalid state (inconsistent metadata) ( |
|
|
|
Indicates whether this materialized view is currently enabled for query rewrite ( |
|
|
|
Length (in bytes) of the query field |
|
|
|
|
|
|
|
|
Reserved for internal use |
See Also: