My Oracle Support Banner

ORA-32319: Cannot Use Direct Loader Log to Fast Refresh Materialized View (Doc ID 1483944.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

The creation or refresh of an on-demand mview fails with ORA-32319 when there is concurrent DML on the parent  table and there is an on commit mview on the parent table. On the primary database, GoldenGate is modifying the base table and no direct load is being done.  However, the testcase reproduced without GoldenGate and without direct load.  When compatibility is set to 10.2 the error is ORA-12034, which is actually expected.  The workaround of creating a 'dummy' on demand mview off of the parent table works in both cases. 

 

Changes

 

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.