Using add_schema_propagation_rules

The section will present information on using the add_schema_propagation_rules procedure to create a Propagation process. This method helps to configure the schema level propagation, and as such, all the objects in the schema will be covered for propagation. 

The add_schema_propagation_rules procedure in the dbms_streams_adm package can be used to configure the Streams propagation to propagate row LCRs and DDL LCRs relating to the specified schema from a queue at source database to a queue at the destination database.

As an example, the replication of NY2 schema will be configured using the following SQL statement.

BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_PROPAGATION_RULES(
schema_name               => 'ny2',
streams_name               => 'ny2_propagate',
source_queue_name    => 'strmadm.ny2_queue',
destination_queue_name => 'strmadm.ln2_queue@dnyoip20.world',
include_dml                  => true,
include_ddl                   => true,
include_tagged_lcr      => false,
source_database          => 'dnytsts10.world',
inclusion_rule                => true);
END;
/