Capture Creation - Using add_schema_rules procedure

Next, the queue and the Apply Process will be created at the destination database, as shown in the following SQL block:

connect strmadm/strmadm@dnyoip20

Prompt Connected to Target DNYREP10
Prompt Step(3) Creating A new Queue (LN2_QUEUE) at destination
BEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE(
queue_table             => 'strmadm.ln2_queue_table',
queue_name             => 'strmadm.ln2_queue');
END;
/
PROMPT Step(4) Create APPLY process schema rules at destination
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
 schema_name             => 'ny2',
 Streams_type             => 'apply',
 Streams_name             => 'ln2_apply',
 queue_name             => 'ln2_queue',
 include_dml             => true,
 include_ddl             => true,
 include_tagged_lcr      => false,
 source_database          => 'dnytst10.world',
 inclusion_rule               => true);
END;
/