Using add_schema_propagation_rules

In the above example, the destination queue of LN2_QUEUE at the DNYOIP20 database has been specified. NY2 schema objects are configured to be propagated to the destination.

If the goal is to use schema rules but there is concern about changes to database objects in a schema that are not supported by Streams, the rules can be used to discard unsupported changes.  The dbms_rules_adm package can be used to achieve this.

Using dbms_propagation_adm to create propagation

The following is an example that uses the create_propagation procedure of the dbms_propagation_adm package to create a propagation:

BEGIN
DBMS_PROPAGATION_ADM.CREATE_PROPAGATION(
propagation_name                    => 'ny4_propagate',
source_queue               => 'strmadm.ny4_queue',
destination_queue                     => 'strmadm.ln4_queue',
destination_dblink                    => 'dnyoip20.world',
rule_set_name             => 'strmadm.ny4_rule_set1');
END;
/

The above example creates the NY4_PROPAGATE propagation to send events from the queue named NY4_QUEUE to the LN4_QUEUE located at DNYOIP20 database.

This method does not create the propagation rules automatically. The pre-created rule set must be specified and associated with this propagation. In the above example, the propagation is associated with an existing rule set named NY4_RULE_SET1. This rule acts as the positive rule set for the propagation.