Technology Stack - EBS (MOSC)

MOSC Banner

invalid materialized view

edited Aug 20, 2021 11:37AM in Technology Stack - EBS (MOSC) 8 commentsAnswered

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.

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