Cant rollback force or commit a "In-Doubt Transactions"
Hi,
I have a In doubt transactions which I cant rollback or commit.
I found some dosc on metalink, but we dont ahve two nodes, the transactions comes from an application server.
I used
select * from DBA_2PC_PENDING;
to get the global_tran_id/local_tran_id
Its state is prepared.
I have used commit rollback and commit force, but the transaction still remains when query the DBA_2PC_PENDING.
How do I get rid of it?
Regards
S