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