Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REFRESH.ADD

Purpose

To add snapshots to a refresh group. For additional information, refer to

Syntax

The parameters for the ADD procedure are described in Table 12 - 56. The syntax for this procedure is shown below.

DBMS_REFRESH.ADD(	name 	IN 	VARCHAR2,
     			list 	IN 	VARCHAR2,
     			lax 	IN 	BOOLEAN DEFAULT FALSE)

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.) Alternatively, you can supply a PL/SQL table of type DBMS_UTILITY.UNCL_ARRAY, where each element is the name of a snapshot.
lax A snapshot can belong to only one refresh group at a time. If you are moving a snapshot from one group to another, 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.

Table 12 - 56. Parameters for DBMS_REFRESH.ADD

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.) Alternatively, you can supply a PL/SQL table of type DBMS_UTILITY.UNCL_ARRAY, where each element is the name of a snapshot.
`lax`	A snapshot can belong to only one refresh group at a time. If you are moving a snapshot from one group to another, 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.