Using add_subset_rules for Apply Creation

connect strmadm/strmadm@dnytst10
PROMPT (8) Starting the Cature Prcoess at source`DNYTST10
begin
dbms_capture_adm.start_capture (capture_name => 'NY3_CAPTURE' ) ;
end ;
/

The next step is to load some rows into the table at the source database by running the load_ny3_allinsured1.sql script. A full listing of this script is provided in the code depot.

Prior to execution of the script, there are no rows either in the source or destination tables. The following SQL statement shows:

select  (select count(*) from ny3.allinsured1) at_source,
(select count(*) from ny3.allinsured1@dnyoip20) at_dest  from dual
/
gives output ..

AT_SOURCE    AT_DEST
---------- ----------
         0          0

Run the script to insert 60,000 records and commits for every 1000 records of insert. Therefore, there are 60 commits.