Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

46
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

Table 46-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.  


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback