Database Error Messages

ORA-40097

Failure to acquire row lock, currently held by transaction ID seg_number.slot_number.wrap_number
  • seg_number: Undo segment number of blocker transaction.
  • slot_number: Slot number of blocker transaction.
  • wrap_number: Wrap number of blocker transaction.

Cause

The current transaction is unable to acquire the row lock on a row because another transaction holds the lock.


Action

Wait for the transaction to release the row lock and try again.