My Oracle Support Banner

Materialized Views (MVIEWs) Refresh Order Using "DBMS_SNAPSHOT.REFRESH" LIST Parameter; 9i Vs 10g and Higher Versions (Doc ID 1452382.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

In 10g and above versions, Oracle does not refresh the MVIEWs in sequence as specified in the "LIST" parameter in the DBMS_SNAPSHOT.REFRESH / DBMS_MVIEW.REFRESH procedure. MVIEWs are sorted and refreshed in alphabetical order from 10g onwards. Whereas in 9i, it refreshes the MVIEWs as specified in LIST parameter; there is no sorting by MVIEW name in 9i.

Changes

Customer used to refresh a set of MVIEWs based on its dependencies in 9i version.  After upgrading to 10g/11g, the same set of MVIEWs are getting refreshed in alphabetical order, and the impact is MVIEWs are not getting correct data as the order is changed.

Cause

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
Symptoms
Changes
Cause
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.