Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01591 --> How to remove blocking distributed transaction?

576410Sep 10 2007 — edited Nov 3 2009
Hi at all,

I've got a big problem! There is a transaction lock on a table and I can't access / update the table. The following error occures: ORA-01591: lock held by in-doubt distributed transaction 140.12.34934.

So, I decided to kill this transaction. But I can't find any transaction with that number. How can I remove this transaction. A restart of the database does not kill this trransaction.

Thanks for you help

Message was edited by:
user573407
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2009
Added on Sep 10 2007
#general-database-discussions
6 comments
8,799 views