1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. USER_MVIEW_ANALYSIS

6.506 USER_MVIEW_ANALYSIS

USER_MVIEW_ANALYSIS describes all materialized views owned by the current user that potentially support query rewrite and that provide additional information for analysis by applications. Its columns are the same as those in ALL_MVIEW_ANALYSIS.

Note:

This view excludes materialized views that reference remote tables or that include references to non-static values such as SYSDATE or USER. This view also excludes materialized views that were created as snapshots before Oracle8i and that were never altered to enable query rewrite.

See Also:

"ALL_MVIEW_ANALYSIS"