Database DataWarehousing (MOSC)

MOSC Banner

Materialized View refresh when this MV contains others Materialized Views

edited Jul 9, 2015 5:23PM in Database DataWarehousing (MOSC) 3 commentsAnswered

I am working on a Bank Compagny and we have to build a DWH.

We have two tables T1 and T2

we have created Materialized View log for these both tables for fast refresh

we have created Materialized View MV_T1 and MV_T2 as select * from T1 , select * from T2

we have a SQL statement S1 who is a select ..... from T1 and T2 with some sub select

we have created a table T as the result from S1

we have created Materialized View log for this table T for fast refresh

we have created Materialized View MV_T as select * from T

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