Using add_subset_rules for Apply Creation

>@load_ny3_allinsured1.sql

Start Time =19-OCT-2004 22:30
Before Loading, the SCN : 13455161
Job ENDED.....Success
End Time =19-OCT-2004 22:30
Total Output Records = 60000
Total Commits        = 60
After Loading the SCN : 13466195

PL/SQL procedure successfully completed.

After applying all of the table inserts, query the v$streams_apply_coordinator view to see the transactions that have applied. The output shows that 60 transactions have been received and applied at destination database.

DNYOIP20 SQL>l
SELECT APPLY_NAME, TOTAL_RECEIVED, TOTAL_APPLIED, TOTAL_ERRORS,
(TOTAL_ASSIGNED - (TOTAL_ROLLBACKS + TOTAL_APPLIED)) BEING_APPLIED,
TOTAL_IGNORED FROM V$STREAMS_APPLY_COORDINATOR
/

Output shows that the 60 transaction were applied: