Oracle Distributed Systems

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.