RE: ORA-02074: cannot Rollback in a distributed transaction

[Boivin, Patrice J]

I don't know if this is related to what we are going through here, apparently Oracle treats transactions via db link as 2-phase commit transactions unless SET TRANSACTION READ ONLY is used.

 

Check dba_2pc_pending to see if you have hung 2-phase commit transactions.

 

If you do, do a search in MetaLink to find out how to remove them.

 

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]

.com