15
DBMS_MVIEW

DBMS_MVIEW enables you to understand capabilities for materialized views and potential materialized views, including their rewrite availability. It also enables you to refresh materialized views that are not part of the same refresh group and purge logs.

This chapter discusses the following topics:

• Summary of DBMS_MVIEW Subprograms

  Note: DBMS_SNAPSHOT is a synonym for DBMS_MVIEW.

  See Also: Oracle9i Replication for more information about using materialized views in a replication environment Oracle9i Data Warehousing Guide for more information about using materialized views in a data warehousing environment

Summary of DBMS_MVIEW Subprograms

Table 15-1 DBMS_MVIEW Package Subprograms

Subprogram	Description
BEGIN_TABLE_REORGANIZATION Procedure	Performs a process to preserve materialized view data needed for refresh.
END_TABLE_REORGANIZATION Procedure	Ensures that the materialized view data for the master table is valid and that the master table is in the proper state.
EXPLAIN_MVIEW Procedure	Explains what is possible with a materialized view or potential materialized view.
EXPLAIN_REWRITE Procedure	Explains why a query failed to rewrite.
I_AM_A_REFRESH Function	Returns the value of the I_AM_REFRESH package state.
PMARKER Function	Returns a partition marker from a rowid. This function is used for Partition Change Tracking (PCT).
PURGE_DIRECT_LOAD_LOG Procedure	Purges rows from the direct loader log after they are no longer needed by any materialized views (used with data warehousing).
PURGE_LOG Procedure	Purges rows from the materialized view log.
PURGE_MVIEW_FROM_LOG Procedure	Purges rows from the materialized view log.
REFRESH Procedure	Consistently refreshes one or more materialized views that are not members of the same refresh group.
REFRESH_ALL_MVIEWS Procedure	Refreshes all materialized views that do not reflect changes to their master table or master materialized view.
REFRESH_DEPENDENT Procedure	Refreshes 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 Procedure	Enables the administration of individual materialized views.
UNREGISTER_MVIEW Procedure	Enables the administration of individual materialized views. Invoked at a master site or master materialized view site to unregister a materialized view.