invalid materialized view
We have this one Materialized View that occasionally becomes invalid on Production, and we are asking why. Google and Metalink learn me that a lot of commands can make it invalid (insert, delete, alter, ...) if done on one of the base tables of the view.
But when trying to do that, I couldn't reproduce. So, it seems like not an exact science, in that any DML will make a Materialize View invalid, but probably there is some additional requirements to have this achieved. Basically, it would be invalid a lot, I guess ...
Anyway, the base question is still : why does my Materialized View become invalid. It' a standard eBS one, nothing special there.