GoldenGate Replicat Fails With SQL Error 1732 Mapping on Materialized View (Doc ID 1381948.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.29 and later
Information in this document applies to any platform.
***Checked for relevance on 17-JUL-2013***

Symptoms

Oracle GoldenGate (OGG) is configured and running.
Replicat fails with following error trying to update an materialized view:

SQL error 1732 mapping OCI Error ORA-01732: data manipulation operation not legal on this view (status = 1732), SQL <DELETE FROM "MYSCHEMA"."MY_MATVIEW_MV" WHERE "EMPID" = :b0

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