| ORA-01591 lock held by in-doubt distributed transaction [message #61068] |
Thu, 25 March 2004 01:58  |
JMP
Messages: 4
Registered: May 2002
|
Junior Member |
|
|
Hi !
I have an error when I want to export one database.
ORA-01591 lock held by in-doubt distributed transaction 9.32.61
There is effectively one distributed transaction in PENDING_TRANS$. By error, I delete the line in these system table and now when I rollback this transaction in SQLPlus (rollback force '9.32.61';), the message is :
ORA-02058 no prepared transaction found with ID '9.32.61'
Do you know how to delete manually this distributed transaction ?
Thank.
JMP
|
|
|
|
| Re: ORA-01591 lock held by in-doubt distributed transaction [message #61076 is a reply to message #61068] |
Fri, 26 March 2004 01:02  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Yip, one is definitely not supposed to delete data from the SYS.PENDING_TRANS$ table :-(
Your best bet is to try and re-insert the data if you still have it. You can even try to use logminer to get the old values back.
If all else fails, call Oracle Support for assistance or re-create the database from scratch.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
