分布式事务ORA-24784报错

栏目: 数据库 · 发布时间: 7年前

内容简介:XA事务和Dblink事务冲突,在DBlink中启动XA事务了,即使仅仅是查询。也就是说:XA事务和DBLink事务两者只能用一个,另外Oracle不支持临时表的XA事务An ORA-24784 'Transaction exists' error occurs when using Oracle XA.An attempt was made to start a transaction, while attached to a non-migrateable transaction

XA事务和Dblink事务冲突,在DBlink中启动XA事务了,即使仅仅是查询。也就是说:XA事务和DBLink事务两者只能用一个,另外Oracle不支持临时表的XA事务

An ORA-24784 'Transaction exists' error occurs when using Oracle XA.

An attempt was made to start a transaction, while attached to a non-migrateable transaction

Issuing a query containing a database link starts a distributed transaction that is non-migratable, even if it is only a query. An XA transaction cannot then be started without a commit or rollback being issued first.

[该贴被banq于2018-10-12 16:34修改过]


以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

Charlotte's Web

Charlotte's Web

E. B. White / Scholastic / 2004 / USD 0.01

This is the tale of how a little girl named Ferm, with the help of a friendly spider, saved her pig, Wilbur, from the usual fate of nice fat little pigs.一起来看看 《Charlotte's Web》 这本书的介绍吧!

SHA 加密
SHA 加密

SHA 加密工具

正则表达式在线测试
正则表达式在线测试

正则表达式在线测试

RGB CMYK 转换工具
RGB CMYK 转换工具

RGB CMYK 互转工具