Syntax

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

Parameters

Table 17-7 SUBTRACT Procedure Parameters

Parameter

Description

name

Name of the refresh group from which you want to remove members.

list

Comma-delimited list of materialized views that you want to remove from the refresh group. (Synonyms are not supported.) These materialized views can be located in different schemas and have different master tables or master materialized views. However, all of the listed materialized views must be in your current database.

tab

Instead of a comma-delimited list, you can supply a PL/SQL index-by table of names of materialized views that you want to refresh using the datatype DBMS_UTILITY.UNCL_ARRAY. If the table contains the names of n materialized views, then the first materialized view should be in position 1 and the n + 1 position should be set to NULL.

lax

Set this to false if you want Oracle to generate an error message if the materialized view you are attempting to remove is not a member of the refresh group.