Re: in-doubt distributed transaction

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 16 Aug 1999 11:46:18 GMT
Message-ID: <7p8tma$knf$5@news.seed.net.tw>

Patrik Stensdahl <patrik.stensdahl_at_kvaerner.com> wrote in message news:7p13u9$e602_at_ftp.kvaerner.com...
> Hi!
>
> I have an in-doubt transaction in a database that I want to get rid of it.
>
> What shall I do?
>
>
> This is the error message:
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------
> ORA-01591: lock held by in-doubt distributed transaction 11.53.673
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------

Issue the command:

ROLLBACK FORCE '11.53.673';
or
COMMIT FORCE '11.53.673'; Received on Mon Aug 16 1999 - 06:46:18 CDT