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 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
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.
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