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) |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.