From ukszupukszu, 2 Years ago, written in Plain Text.
This paste is a reply to hehe from ukszupukszu - view diff
Download Paste or View Raw
Hits: 233
  1. Error at Command Line:107 Column:0
  2. Error report:
  3. SQL Error: ORA-02055: distributed update operation failed; rollback required
  4. ORA-00001: unique constraint (STUDENT.EMPLOYEE_ID_PK_OTHERS) violated
  5. ORA-02063: preceding line from FOO
  6. ORA-06512: at "STUDENT.ON_EMPLOYEES_UPDATE", line 9
  7. ORA-04088: error during execution of trigger 'STUDENT.ON_EMPLOYEES_UPDATE'
  8. 02055. 00000 -  "distributed update operation failed; rollback required"
  9. *Cause:    a failure during distributed update operation may not have
  10.            rolled back all effects of the operation.  Since
  11.            some sites may be inconsistent, the transaction must roll back to
  12.            savepoint or entirely
  13. *Action:   rollback to a savepoint or rollback transaction and resubmit
  14. rollback complete.