PL/SQL Packages DBMS_MVIEW

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
Related Commands:

Related Views:

 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 © 1999-2024 SS64.com
Some rights reserved