Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REFRESH.SUBTRACT

Purpose

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

Syntax

The parameters for the SUBTRACT procedure are described in Table 12 - 61. The syntax for this procedure is shown below:

DBMS_REFRESH.SUBTRACT(	name 	IN 	VARCHAR2,
          			list 	IN 	VARCHAR2,   |
					IN	DBMS_UTILITY.UNCL_ARRAY,
          			lax 	IN 	BOOLEAN DEFAULT FALSE)

parameter description
name Name of the refresh group from which you want to remove members.
list Comma-separated list of snapshots that you want to remove from 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 Set this parameter to FALSE if you want Oracle to generate an error message if the snapshot you are attempting to remove is not a member of the refresh group.

Table 12 - 61. Parameters for DBMS_REFRESH.SUBTRACT

parameter	description
`name`	Name of the refresh group from which you want to remove members.
`list`	Comma-separated list of snapshots that you want to remove from 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`	Set this parameter to FALSE if you want Oracle to generate an error message if the snapshot you are attempting to remove is not a member of the refresh group.