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.