分布式事务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修改过]


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

查看所有标签

猜你喜欢:

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

Learning Web Design

Learning Web Design

Jennifer Niederst Robbins / O'Reilly Media / 2007-6-15 / USD 44.99

Since the last edition of this book appeared three years ago, there has been a major climate change with regard to web standards. Designers are no longer using (X)HTML as a design tool, but as a means......一起来看看 《Learning Web Design》 这本书的介绍吧!

CSS 压缩/解压工具
CSS 压缩/解压工具

在线压缩/解压 CSS 代码

UNIX 时间戳转换
UNIX 时间戳转换

UNIX 时间戳转换

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

RGB CMYK 互转工具