My Oracle Support Banner

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 later
Information 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


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