Refresh materialized views (MVIEWS), purge logs and understand the capabilities of an mview.
Subprocedures: BEGIN_TABLE_REORGANIZATION Perform a process to preserve materialized view data needed for refresh. END_TABLE_REORGANIZATION Ensure that the materialized view data for the master table is valid and that the master table is in the proper state. EXPLAIN_MVIEW Explain what is possible with a materialized view or potential materialized view. EXPLAIN_REWRITE Explain why a query failed to rewrite. I_AM_A_REFRESH Function Return the value of the I_AM_REFRESH package state. PMARKER Function Return a partition marker from a rowid. This function is used for Partition Change Tracking (PCT). PURGE_DIRECT_LOAD_LOG Purge rows from the direct loader log after they are no longer needed by any materialized view (used with data warehousing). PURGE_LOG Purge rows from the materialized view log. PURGE_MVIEW_FROM_LOG Purge rows from the materialized view log. REFRESH Consistently refresh one or more materialized views that are not members of the same refresh group. REFRESH_ALL_MVIEWS Refresh all materialized views that do not reflect changes to their master table or master materialized view. REFRESH_DEPENDENT Refresh all table-based materialized views that depend on a specified master table or master materialized view, or list of master tables or master materialized views. REGISTER_MVIEW Administer an mview. UNREGISTER_MVIEW Unregister an mview. Invoked at a master site or master mview site
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
DBA_MVIEWS ALL_MVIEWS USER_MVIEWS DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES DBA_MVIEW_ANALYSIS ALL_MVIEW_ANALYSIS USER_MVIEW_ANALYSIS DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS DBA_MVIEW_JOINS ALL_MVIEW_JOINS USER_MVIEW_JOINS DBA_MVIEW_KEYS ALL_MVIEW_KEYS USER_MVIEW_KEYS
© Copyright SS64.com 1999-2013
Some rights reserved