Database Software

Hi All,

We are working on OWB10gr2. I would like share one requirement. Any one can suggest me how to do it and which is the best way to get accurate information.

We have 2 schemas’ like nia_src and nia_tgt. currently we are moving data from nia_src to nia_tgt for that reason we implemented some mappings based on requirement. In my source schema (nia_src) having 100 tables with data and similar structure replicated in target schema (nia_tgt).

In source schema every table having one date field for which record is inserted and based on that field we can find how may records are inserted on particular table ,particular time.

Same like target also maintaining date fields for tracking purposes.

We have done some mappings and scheduled also. Every day we are into the target with incremental data. All are working fine not any issues.


I wanted to know how many records inserted, updated, merged for particular batch
How can we find?
Can we find exact information in OWB_REP_OWNER schema on WB_RT_AUDIT?.

For tracking purposes I need to find those values how many records are available in
Source table and how many records are populated to the target schema?

How to find schedule batch count of records table wise for batch wise?


Please suggest me any one on this.

thanks and regards,
venkat.