ORA-32319: Cannot Use Direct Loader Log to Fast Refresh Materialized View
Last updated on SEPTEMBER 12, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 184.108.40.206 [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 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.
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