ALL_MVIEW_ANALYSIS

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

Related:


© Copyright SS64.com 1999-2014
Some rights reserved