Using add_table_propagation_rules

• It creates a positive rule set and associates it with the propagation because the inclusion_rule parameter is set to TRUE. The rule set uses the evaluation context sys.streams$_evaluation_context. The rule set name is specified by the system.
   

• It creates two rules. One rule evaluates to TRUE for row LCRs that contain the results of DML changes to the NY1.ALLINSURED1 table.  The other rule evaluates to TRUE for DDL LCRs that contain DDL changes to the NY1.ALLINSURED1 table. The rule names are specified by the system.
   

• It adds the two rules to the positive rule set associated with the propagation since the inclusion_rule is set to TRUE.

The following SQL statement can be executed to view the propagation details:

SELECT p.propagation_name propagation_name,
 TO_CHAR(s.start_date, 'HH24:MI:SS MM/DD/YYYY') START_DATE,
  s.propagation_window DURATION, s.latency, s.schedule_disabled,
  TO_CHAR(s.next_run_date,'HH24:MI:SS MM/DD/YYYY') NEXT_TIME,
  process_name, total_number, failures
  FROM dba_queue_schedules S, dba_propagation P
  SEE CODE DEPOT FOR FULL SCRIPT
 (select propagation_name from DBA_PROPAGATION)
/