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.