Replication Management API Reference, 46 of 179

ADD procedure

This procedure adds snapshots to a refresh group.

See Also:
"ADD OBJECTS TO REFRESH GROUP", and see Chapter 3, "Snapshot Concepts & Architecture" in Oracle8i Replication for more information.

DBMS_REFRESH.ADD (
   name     IN VARCHAR2,
   { list   IN VARCHAR2, 
   | tab    IN DBMS_UTILITY.UNCL_ARRAY, }
   lax      IN BOOLEAN := FALSE);

Note:
This procedure is overloaded. The list and tab parameters are mutually exclusive.

Parameter	Description
name	Name of the refresh group to which you want to add members.
list	Comma-separated list of snapshots that you want to add to the refresh group. (Synonyms are not supported.)
tab	Instead of a comma-separated list, you can supply a PL/SQL table of type `DBMS_UTILITY`.`UNCL_ARRAY`, where each element is the name of a snapshot. The first snapshot should be in position 1. The last position must be `NULL`.
lax	A snapshot can belong to only one refresh group at a time. If you are moving a snapshot from one group to another, then you must set the `lax` flag to `TRUE` to succeed. Oracle then automatically removes the snapshot from the other refresh group and updates its refresh interval to be that of its new group. Otherwise, the call to `ADD` generates an error message.