29
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 29-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.