Using add_subset_rules for Apply Creation

queue_name      => 'ny3_queue',
include_dml     => true,
include_ddl     => true,
include_tagged_lcr => false,
source_database => NULL,
inclusion_rule  => true);
END;
/

At the destination, the Apply Process will be created using the add_subset_rules procedure where the dml_condition sales_id > 100 has been set.

The following is a full example involving the Capture, the Propagation at the source database and a subset data apply at destination.

At destination database side, create the queue and Apply process:

connect strmadm/strmadm@dnyoip20

PROMPT (3) Creating Queue Table at Destination ..
BEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE(
queue_table     => 'strmadm.ln3_queue_table',
queue_name      => 'strmadm.ln3_queue');
END;
/