My Oracle Support Banner

ODI-1228: ORA-12008: Error In Materialized View Refresh Path - B1_OPR_DEVICE_SNAP_MON_MV1 (Doc ID 2526726.1)

Last updated on MARCH 25, 2021

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.9 and later
Information in this document applies to any platform.

Goal

On :  2.7.0.0.10 version, Install / Upgrade

ODI-1228:  ORA-12008: error in materialized view refresh path - B1_OPR_DEVICE_SNAP_MON_MV1  

Checking the MV in the dba_mviewss table, the status of this table is Stale but valid. other MVs have a status of "needs_compile".

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.