MView on a Partitioned table
Debasish Dutta, September 05, 2017 - 7:17 am UTC
Hi Tom,
Based on your answer, one query popped up in my mind. Can you please help me.
What if I want to create a non-partitioned matview on a partitioned table. If I drop any partition of the table, would it invalidate the matview and the refresh will fail? If yes, how can I overcome it so that the matview is not invalidated even if I drop any particular partition.
September 05, 2017 - 2:09 pm UTC