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

Last updated on SEPTEMBER 12, 2016

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 master 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. 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms