What Causes So Many Invalid Materialized Views in A Database

(Doc ID 454552.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle E-Business Intelligence - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle E-Business Intelligence - Version 12 to 12.2 [Release 12.0 to 12.2]
Oracle Database - Enterprise Edition - Version 9.2.0.4 to 12.2.0.1 [Release 9.2 to 12.2]
Information in this document applies to any platform.
Checked for currency 22-Jun-2017

Goal

Database has Materialized views that are invalid. How Do MVs become Invalid?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms