Re: How to rollback prepared tramsaction

On Sat, 2024-03-02 at 15:35 -0300, Eriovaldo Andrietta wrote:
> Hello 
> I have a prepared tramsaction that I can see It in SELECT * FROM
> GV$TRANSACTION WHERE STATUS = 'PREPARED';
>
> It was executed yesterday. 
> How can I rollback It ?
>
> Note: the transcaction is not via database link.
>
> Regards
> Eriovaldo 

DBMS_TRANSACTION.ROLLBACK_FORCE
https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_TRANSACTION.html#GUID-6FD071A6-9684-4219-8A52-4EFFF9682784

-- 
Mladen Gogala
Database SME
https://dbwhisperer.wordpress.com


--
http://www.freelists.org/webpage/oracle-l