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

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-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.