My Oracle Support Banner

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 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 (<>) violated.
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.