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

DRG-12434: connection failed using configuration string information

1 Answers  


ORA-29934: index specified for association is not a domain index

1 Answers  


ORA-29885: domain index is defined on the column to be modified

1 Answers  


ORA-38609: FI Not enough memory for tree counting, requires at least stringKB

1 Answers  


NNL-00231: Controller NOCONFIRM mode is now string

1 Answers  






RMAN-08527: channel string: starting string proxy datafile backup at string

1 Answers  


ORA-25179: invalid PCTTHRESHOLD storage option value

1 Answers  


ORA-01353: existing Logminer session

1 Answers  


ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 Answers  


EXP-00051: "string" - given partition or subpartition name is not part of "string" table

1 Answers  


RMAN-08033: channel string: including datafilecopy of datafile string in backupset

1 Answers  


ORA-29268: HTTP client error string

1 Answers  


Categories