Sunday 22 January 2012

ORA-02092: out of transaction table slots for distributed transaction

ORA-02092: out of transaction table slots for distributed transaction

Cause: The transaction is assigned to the system rollback segment and is trying to get into the PREPARED state, but the required number of non-PREPARED slots are not available, hence the transaction is rolled back.

Action: Add a rollback segment and retry the transaction.

No comments:

Post a Comment