Description of the materialized views accessible to the user
Columns
___________________________
OWNER
Owner of the materialized view
MVIEW_NAME
Name of the materialized view
MVIEW_TABLE_OWNER
Owner of the container table
CONTAINER_NAME
Name of the container table for this materialized view
LAST_REFRESH_SCN
The SCN of the last transaction to refresh the materialized view
LAST_REFRESH_DATE
The date of the last refresh of the materialized view
REFRESH_METHOD
User declared method of refresh for the materialized view
SUMMARY
Indicates if the materialized view includes the GROUP BY clause
FULLREFRESHTIM
The time that it took to fully refresh the materialized view
INCREFRESHTIM
The time that it took to incrementally refresh the materialized view
CONTAINS_VIEWS
This materialized view contains views in the FROM clause
UNUSABLE
This materialized view is unusable,the build was deferred
RESTRICTED_SYNTAX
This materialized view contains restrictive syntax
INC_REFRESHABLE
This materialized view is not restricted from being incrementally refreshed
KNOWN_STALE
This materialized view is directly stale
INVALID
Invalidity of the materialized Y = INVALID,N = VALID
REWRITE_ENABLED
This materialized view is enabled for query rewrite
QUERY_LEN
The length (in bytes) of the query field
QUERY
SELECT expression of the materialized view definition
REVISION
Reserved for internal use