Forum Stats

  • 3,740,274 Users
  • 2,248,218 Discussions
  • 7,861,153 Comments

Discussions

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.