My Oracle Support Banner

Materialized View Not Running After Being Disabled Then Re-enabled (Doc ID 2266176.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version to [Release 2.6 to 2.7]
Information in this document applies to any platform.


 OUA 2.6.0 and 2.7.0

Materialized view not running after being disabled then re-enabled

If the Materialized view ends up in error and does not get completed even after retry for the day.

This entity is disable for the day and enabled after2 days. The entity does not appear in the ready view.

Steps to Reproduce

Follow the steps below to reproduce the issue:
1. Enable the load for the MV.

2. The MV load ends in error even after maximum retry per day is reached.

3. Disable the MV load.

4. After 2 days enable the MV load , this MV does not appear in the ready view.


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

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