PL/SQL Packages DBMS_REFRESH
Create groups of materialized views that can be refreshed together to a transactionally consistent point in time.
Subprocedures:
ADD Add materialized views to a refresh group.
CHANGE Change the refresh interval for a refresh group.
DESTROY Remove all the materialized views from a refresh group and
delete the refresh group.
MAKE Specify the members of a refresh group and the time interval
used to determine when the members of this group should be refreshed.
REFRESH Manually refresh a refresh group.
SUBTRACT Remove materialized views from a refresh group.
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_REFRESH ALL_REFRESH USER_REFRESH DBA_REFRESH_CHILDREN ALL_REFRESH_CHILDREN USER_REFRESH_CHILDREN