分布式事务ORA-24784报错

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

内容简介: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修改过]


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

查看所有标签

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

The Filter Bubble

The Filter Bubble

Eli Pariser / Penguin Press / 2011-5-12 / GBP 16.45

In December 2009, Google began customizing its search results for each user. Instead of giving you the most broadly popular result, Google now tries to predict what you are most likely to click on. Ac......一起来看看 《The Filter Bubble》 这本书的介绍吧!

URL 编码/解码
URL 编码/解码

URL 编码/解码

MD5 加密
MD5 加密

MD5 加密工具

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

RGB CMYK 互转工具