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 Views: 
 DBA_REFRESH           ALL_REFRESH           USER_REFRESH 
 DBA_REFRESH_CHILDREN  ALL_REFRESH_CHILDREN  USER_REFRESH_CHILDREN 

 
Copyright © 1999-2024 SS64.com
Some rights reserved