Dropping the Propagation

The drop_propagation procedure in the dbms_propagation_adm package can be used to drop an existing propagation. Why would there be a need to drop a propagation?  For example, if a particular site is no longer maintaining a data replica, it may be desirable to remove a propagation for that site.

For example, the following procedure drops a propagation named NY4_PROPAGATE:

BEGIN
DBMS_PROPAGATION_ADM.DROP_PROPAGATION(
propagation_name => 'NY4_PROPAGATE',
drop_unused_rule_sets => TRUE);
END;
/

Since the drop_unused_rule_sets parameter is set to TRUE, this procedure also drops any rule sets used by the propagation NY4_PROPAGATE, unless the rule set is used by another Streams client. If this procedure drops a rule set, it also drops any rules in the rule set that do not exist in another rule set. 

The next section presents information on how to alter the settings and properties of the Propagation process.