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