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-29813: non-supported object type with associate statement

1 Answers  


ORA-22062: invalid input string [string]

1 Answers  


CLSS-00001: skgxn not active

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


RMAN-20209: duplicate datafile name

1 Answers  






ORA-19687: SPFILE not found in backup set

1 Answers  


ORA-26091: requested direct path operation not supported

1 Answers  


RMAN-11001: Oracle Error: string

1 Answers  


ORA-23456: flavor string does not contain "string"

1 Answers  


ORA-16131: An error occurred during a Terminal Recovery of the standby.

1 Answers  


ORA-22615: attribute is not a collection

1 Answers  


ORA-08106: cannot create journal table string.string

1 Answers  


Categories