R12.1.3 : Materialized views getting invalid
Hi,
The materialized views get invalid.
there is no patching activity but randomly the MV are invalid.
So then I recompile the materialized views with no problem, but in the course of using the system,
they end up invalid again some days later,
An so on.
From document :
What Causes So Many Invalid Materialized Views (Doc ID 454552.1)
=======================================================
This is expected behavior when an update is made to a table that the materialized view references.
The
dba_objects table will report the status as invalid. It is normal
behavior for dba_objects to return INVALID status for materialized views
after the base tables have been updated.