END_TABLE_REORGANIZATION Ensures that the materialized view master table is in the
proper state and that the master table is valid, at the end
of a master table reorganization.
ESTIMATE_MVIEW_SIZE Estimates the size of a materialized view, in bytes and rows.
EXPLAIN_MVIEW Explains what is possible with an existing or proposed
materialized view. (Is it fast refreshable? Is query rewrite
available?)
EXPLAIN_REWRITE Explains why a query failed to rewrite, or which
materialized views will be used if it rewrites.
I_AM_A_REFRESH The value of the I_AM_REFRESH package state is
returned, called during replication.
PMARKER Used for Partition Change Tracking. Returns a partition
marker from a RowID.
PURGE_DIRECT_LOAD_LOG Used with data warehousing, this subprogram purges
rows from the direct loader log after they are no longer
needed by a materialized view.
PURGE_LOG Purges rows from the materialized view log.
PURGE_MVIEW_FROM_LOG Purges rows from the materialized view log.
REFRESH Refreshes one or more materialized views that are not
members of the same refresh group.
REFRESH_ALL_MVIEWS Refreshes all materialized views that do not reflect
changes to their master table or master materialized view.
REFRESH_DEPENDENT Refreshes all table-based materialized views that depend
on either a specified master table or master materialized
view. The list can contain one or more master tables or
master materialized views.
REGISTER_MVIEW Enables an individual materialized view??™s administration.
Pages:
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907