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 188.8.131.52.29 and later
Information in this document applies to any platform.
***Checked for relevance on 17-JUL-2013***
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!