ALL_MVIEW_ANALYSIS

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 Corporation recommends that you refer to ALL_MVIEWS for this information instead of these views.

  Column	Datatype	NULL	Description
  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	Length (in bytes) of the query field
  QUERY	LONG	NOT NULL	SELECT expression of the materialized view definition
  REVISION	NUMBER		Reserved for internal use