Materailized Views
Team,
10.2.0.4
Linux AS4.
I have got below queries on Mviews. Please help me out over this ?
1) In Which cases, MV Logs wil be cleared ? ( fast/force/complete refresh)
2) In COMPLETE refresh, is it ture that we don't need MV logs ?
3) My MV jobs are running for every 5 mins from DBA_JOBS. What happen if the MV is unable to refresh in 5 mins?
4) We have data replication from OLTP to OLAP env through MVs. All Mviews are refreshing fine without any failures. But we have huge difference in record count b/w these table when compared OLTP -- > OLAP.
Is this okay as long as mview is refreshing or do we need to make it sync with primary table in OLAP.
0