Database DataWarehousing (MOSC)

MOSC Banner

Materailized Views

edited Mar 30, 2012 5:18AM in Database DataWarehousing (MOSC) 2 commentsAnswered
 
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center