Using
add_table_propagation_rules
table_name =>
'ny1.allinsured1',
streams_name =>
'ny1_propagate',
source_queue_name =>
'strmadm.ny1_queue',
destination_queue_name
=> 'strmadm.ln1_queue@DNYOIP20.world',
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
source_database =>
'DNYTST10.world',
inclusion_rule => true);
END;
/
The above procedure performs the following:
-
It creates a propagation named
NY1_PROPAGATE.
-
It specifies that the LCRs are to be
propagated from NY1_QUEUE in the current database to LN1_QUEUE
in the DYNOIP20.WORLD database.
-
It specifies that the propagation uses the
DNYOIP20.WORLD database link to propagate the LCRs because the
destination_queue_name parameter contains DNYOIP20.WORLD.
