Oracle Distributed Systems

DBMS_REFRESH: Managing Snapshot Groups

The DBMS_REFRESH package contains procedures for administering snapshot groups.

How the Package Is Used

A snapshot group is a collection of one or more snapshots that Oracle refreshes in an atomic transaction, guaranteeing that relationships among the master tables are preserved in the snapshot tables.

Installation and Access

The DBMS_REFRESH package is created when the Oracle database is installed. The dbmssnap.sql script (found in the built-in packages source directory) contains the source code for this package’s specification. This script is called by catproc.sql, which is normally run immediately after database creation. The script creates the public synonym DBMS_REFRESH for the package and grants the EXECUTE privilege on the package to public. All Oracle users can reference and make use of this package.

DBMS_REFRESH Procedures

Procedure Name	Description
ADD	Adds one or more snapshots to an existing refresh group
CHANGE	Changes parameters associated with a refresh group
DESTROY	Removes a refresh group
MAKE	Creates a refresh group
REFRESH	Forces a refresh of a refresh group
SUBTRACT	Removes one or more snapshots from a refresh group

DBMS_REFRESH does not define any exceptions.

DBMS_REFRESH Nonprogram Elements

Element Name/Type	Description
aaspriv/BINARY INTEGER	Privilege number for ALTER ANY SNAPSHOT system privilege (107)