19
DBMS_REFRESH

DBMS_REFRESH enables you to create groups of materialized views that can be refreshed together to a transactionally consistent point in time.

This chapter discusses the following topics:

• Summary of DBMS_REFRESH Subprograms

Summary of DBMS_REFRESH Subprograms

Table 19-1 DBMS_REFRESH Package Subprograms

Subprogram	Description
ADD Procedure	Adds materialized views to a refresh group.
CHANGE Procedure	Changes the refresh interval for a refresh group.
DESTROY Procedure	Removes all of the materialized views from a refresh group and deletes the refresh group.
MAKE Procedure	Specifies the members of a refresh group and the time interval used to determine when the members of this group should be refreshed.
REFRESH Procedure	Manually refreshes a refresh group.
SUBTRACT Procedure	Removes materialized views from a refresh group.