For Each Row Trigger is Fired Across DBLINK Multiple Times
(Doc ID 2668061.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
DML statements are failed by below errors.
------------------------------------------------------------
ORA-02055: distributed update operation failed; rollback required
ORA-00001: UNIQUE CONSTRAINT(<CONSTRAINT_NAME>) VIOLATED
ORA-02063: preceding line from <DB_LINK_NAME>
ORA-06512: "<TRIGGER_NAME>", line
ORA-04088: error during execution of trigger'<TRIGGER_NAME>'
------------------------------------------------------------
The symptom can be caused on below situation.
1) A table has a trigger with "BEFORE DELETE OR UPDATE" and "FOR EACH ROW" clause.
and
2) A trigger will update a table on remote site when a trigger is fired.
example)
Note:
Number of rows, number of triggers and parallel degrees are not related to.
Changes
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 |
Changes |
Cause |
Solution |
References |