Forum Stats

  • 3,826,771 Users
  • 2,260,705 Discussions


MV is showing less number of records in dr than prod

Hi All,

We have an oracle 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.