Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-26786

A row with key string exists but has conflicting column(s) string in table string

Cause

The row to update or delete exists in the table but had conflicting value for some columns.


Action

For Streams and XStream, please define a conflict resolution, or resolve the conflict and execute the error transaction using DBMS_APPLY_ADM.EXECUTE_ERROR. For logical standby, please verify the status of the database guard to ensure local modifications are not allowed, then re-instantiate the table and contact support if the problem persists. For GoldenGate, configure Conflict Resolution (CDR) or REPERROR handler for the table and restart replicat. For Sharding, if the apply process has been stopped, gather apply traces, debug and alert logs, and contact Oracle Support if the problem persists.