For Each Row Trigger is Fired Across DBLINK Multiple Times (Doc ID 2668061.1)

Last updated on JULY 20, 2024

Applies to:

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

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