|
Code Listing 1: Creating the propagation process and rules
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'scott.emp',
streams_name => 'TEST10G1_to_TEST10G2',
source_queue_name => 'strmadmin.streams_queue',
destination_queue_name => 'strmadmin.streams_queue@TEST10G2',
include_dml => true,
include_ddl => true,
source_database => 'TEST10G1',
inclusion_rule => true);
END;
/
|