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;
/
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy