GoldenGate Replicat Fails With SQL Error 1732 Mapping on Materialized View
(Doc ID 1381948.1)
Last updated on SEPTEMBER 23, 2018
Applies to:
Oracle GoldenGate - Version 11.1.1.0.29 and laterInformation 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
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
Symptoms |
Cause |
Solution |