Description of the materialized views created by 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
--
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