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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  


ORA-02354: error in exporting/importing data string

1 Answers  


TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


PCC-02389: Arrays not allowed as input bind variables in SELECT list

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  






ORA-28116: insufficient privileges to do direct path access

1 Answers  


ORA-16047: DGID mismatch between destination setting and standby

1 Answers  


SQL*Loader-00513: Unable to close file (string)

1 Answers  


ORA-14610: Lob attributes not specified for lob column string for subpartition string

1 Answers  


NNL-00229: Request-processing delay is now disabled

1 Answers  


DRG-52203: invalid object name: string

1 Answers  


EXP-00028: failed to open string for write

1 Answers  


Categories