Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable do DROP ROLLBACK SEGEMENT
Thank you for your detailed explanations.
There are 8 indoubt-transactions in 7 segments.
The question is : how can I get back the transaction ID to rollback them, as
DBA_2PC_PENDING is empty.
Before I emptied DBA_2PC_PENDING, I tried to force rollback , but I get an error
(unknown transaction). My feeling is segments believe they are involved in
transactions that are no more handled by Oracle. Looks like a dead lock !
-- Ce message a ete poste via la plateforme Web club-Internet.fr This message has been posted by the Web platform club-Internet.fr http://forums.club-internet.fr/Received on Thu Mar 11 2004 - 04:04:56 CST