ADD Procedure

This procedure adds materialized views to a refresh group.

See Also: Step 6, "Add objects to refresh group," and Oracle Database Advanced Replication for more information

Syntax

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.

Parameters

Table 17-2 ADD Procedures Parameters

Parameter	Description
name	Name of the refresh group to which you want to add members.
list	Comma-delimited list of materialized views that you want to add to the refresh group. (Synonyms are not supported.)
tab	Instead of a comma-delimited list, you can supply a PL/SQL index-by table of type DBMS_UTILITY.UNCL_ARRAY, where each element is the name of a materialized view. The first materialized view should be in position 1. The last position must be NULL.
lax	A materialized view can belong to only one refresh group at a time. If you are moving a materialized view from one group to another, then you must set the lax flag to true to succeed. Oracle then automatically removes the materialized view 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.