Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : Materialized views getting invalid

edited Mar 26, 2013 8:22AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center