Oracle Solution for Error ora-02092

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

What triggered 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.

What should we do to fix it:

Add a rollback segment and retry the transaction.