Altering the Propagation Settings

The alter_propagation procedure of dbms_propagation_adm package can be used to add, alter, or remove a rule set for a propagation.

The following is the syntax of the alter_propagation procedure:

DBMS_PROPAGATION_ADM.ALTER_PROPAGATION(
propagation_name                    IN VARCHAR2,
rule_set_name                         IN VARCHAR2 DEFAULT NULL,
remove_rule_set                       IN BOOLEAN DEFAULT false,
negative_rule_set_name             IN VARCHAR2 DEFAULT NULL,
remove_negative_rule_set             IN BOOLEAN DEFAULT false);

If the remove_rule_set parameter is set to TRUE, it removes the positive rule set for the specified propagation. When a positive rule set for a propagation is removed and the propagation does not have a negative rule set, the propagation will propagate all events.

If the remove_negative_rule_set parameter is set to TRUE, it removes the negative rule set for the specified propagation.