Name
DBMS_REFRESH.ADD
Synopsis
Call the ADD procedure to add one or more snapshots to all existing snapshot groups or move a snapshot from one group to another.
PROCEDURE DBMS_REFRESH.ADD (name IN VARCHAR2, {list IN VARCHAR2,| tab IN dbms_utility.uncl_array,} lax IN BOOLEAN DEFAULT FALSE );
A snapshot group cannot have more than 100 members.
In both Oracle7 and Oracle8, the ADD procedure is overloaded; you can supply the list of snapshots either as a comma-separated string with the list parameter, or as a PL/SQL table with the tab parameter. You must select either the list or tab parameter, but not both.
Parameters
Parameter Name | Description |
---|---|
name | Name of the refresh group to create. |
list | A comma-delimited string of snapshots to include in the new refresh group. Use either list or tab to specify the snapshot(s) you want to add. |
tab | A PL/SQL table of snapshots to include in the new refresh group. Use either list or tab to specify the snapshot(s) you want to add. |
lax | If set to TRUE and the snapshots already exist in a refresh group other than name, the snapshots are first removed from the other group. |
Exceptions
Exception Name/Type | Description |
---|---|
aaspriv/BINARY INTEGER | Privilege number for ALTER ANY SNAPSHOT system privilege |
Restrictions
This procedure must be run from the snapshot site.
A snapshot cannot belong to more than one refresh group.
If you want to move a snapshot from one refresh group to another, the lax parameter must be set to TRUE, which is not the default.
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.