Dropping Materialized Views
613991Sep 11 2012 — edited Sep 11 2012If you drop a materialized view all dependents of the dropped view become invalidated.
Question is: When you recreate that Material View does the invalidated dependents get recompiled/re-validated or do you need to recompile the dependent material views?
Reason I ask is that most of the DROP statements indicate what happens when you recreate the dropped object but the materialized view DROP statement does not.