MV is showing less number of records in dr than prod

Raj012345

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,