Refresh Of Materialized View Fails With Error ORA-00001 And ORA-06512 After Upgrade from 11204 to 18C
(Doc ID 2635331.1)
Last updated on AUGUST 15, 2023
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
There are triggers (After UPDATE,INSERT,DELETE) on the Materialized view. The triggers write to another table.
Update statements on the materialized view, are triggered as inserts statements.
The insert is failing with ORA-00001: unique constraint (<
These triggers worked fine in 11204.
When the triggers fail to insert the rows into the third table, the insert into Materialized view is rolled back and refresh fails.
Upgrade from 11204 to 18C.
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