Forum Stats

  • 3,757,928 Users
  • 2,251,293 Discussions
  • 7,869,969 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,