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

Oracle Error Message

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

Reason for the Error

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.

Solution

Add a rollback segment and retry the transaction.