Forum Stats

  • 3,715,494 Users
  • 2,242,774 Discussions
  • 7,845,364 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

MV is showing less number of records in dr than prod

Hi All,


We have an oracle 11.2.0.4 with OGG replication between PROD & DR

The PROD & DR has a MV . both has same setup (prod has own base table & dr also same ).

Base tables row count between prod & dr is same.

But the MV records in the DR is less than prod in some days and some days it is equal.


We have checked MV DDL & refresh method all are same.


I couldn't share the scripts due to restrictions.


Any help on this.


Thanks,

Sign In or Register to comment.