Using add_table_propagation_rules

To list the rules associated with the Propagation process, the following SQL statement can be used:

SELECT Streams_name, table_owner || '.'|| table_name Table_N_Owner,
source_database, rule_type ,
rule_name, rule_owner, include_tagged_lcr
FROM DBA_STREAMS_TABLE_RULES
SEE CODE DEPOT FOR FULL SCRIPT
/

A more detailed view of the propagation can be obtained by running the following SQL statement:

set linesize 140
COLUMN propagation_name FORMAT A26
COLUMN start_date                     FORMAT a20
COLUMN propagation_window            FORMAT 99999
COLUMN next_time HEADING 'Next Window' FORMAT A12
COLUMN latency                          FORMAT 99999
COLUMN schedule_disabled HEADING 'Disabl' FORMAT A6
COLUMN process_name HEADING PROC FORMAT A8
COLUMN failures             FORMAT 999
COLUMN total_num                     FORMAT 99999999
col propagate_schedule_profile format a60