My Oracle Support Banner

MVIEW of Child Table is Refreshed but MVIEW of Parent Table with Foreign Key Constraint is not Refreshed (Doc ID 2697569.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

・ Tab1 is parent table with a primary key
・ Child table Tab2 and Tab3 have foreign key constraints referencing the primary key of Tab1
・ M_TAB1 is mview based of Tab1
・ M_TAB2 is mview based of Tab2
・ M_TAB3 is mview based of Tab3
・ Insert data into Tab1/Tab2/Tab3 on one session
・ Refresh M_TAB1/M_TAB2/M_TAB3 with atomic_refresh=>TRUE and list  option on other session at the same time .

・MVIEW of Child Table M_TAB2/M_TAB3 are Refreshed with the new data
・MVIEW of Parent Table M_TAB1 may be not Refreshed with some new data

Changes

 None

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.