Materialized View refresh when this MV contains others Materialized Views
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