原贴
http://topic.csdn.net/u/20110308/21/f6b2ea56-68a7-4ad4-b93e-54e9fb014bcb.html
困扰了一个月,后经一个朋友查到原因,确认是个BUG,和大家分享下,一周后结贴。Bug 8432019 - Wrong Results With Full Outer Join, Database Link and Merged Inline View [ID 8432019.8]
________________________________________
Modified 01-SEP-2010 Type PATCH Status PUBLISHED Bug 8432019 Wrong Results With Full Outer Join, Database Link and Merged Inline View
This note gives a brief overview bug 8432019.
The content was last updated on: 01-SEP-2010
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 9 but BELOW 12.1
Versions confirmed as being affected • 11.2.0.1
• 11.1.0.7
• 10.2.0.4 Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in • 12.1 (Future Release)
• 11.2.0.2 (Server Patch Set) Symptoms: Related To:
• Wrong Results
• Database Link / Distributed
• ANSI Joins Description
A full outer join query with inline view executing remotely gets wrong result
missing rows when the inline view is merged.
Rediscovery Notes:
If a full outer join query is executed without native full outer join over a
database link and produces wrong results (missing rows) and the join involves
an inline view which is being merged then you may have encountered this bug.
Workaround
Use native full outer join or prevent the inline view from merging
by adding a NO_MERGE hint.
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
References
Bug:8432019 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
http://topic.csdn.net/u/20110308/21/f6b2ea56-68a7-4ad4-b93e-54e9fb014bcb.html
困扰了一个月,后经一个朋友查到原因,确认是个BUG,和大家分享下,一周后结贴。Bug 8432019 - Wrong Results With Full Outer Join, Database Link and Merged Inline View [ID 8432019.8]
________________________________________
Modified 01-SEP-2010 Type PATCH Status PUBLISHED Bug 8432019 Wrong Results With Full Outer Join, Database Link and Merged Inline View
This note gives a brief overview bug 8432019.
The content was last updated on: 01-SEP-2010
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 9 but BELOW 12.1
Versions confirmed as being affected • 11.2.0.1
• 11.1.0.7
• 10.2.0.4 Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in • 12.1 (Future Release)
• 11.2.0.2 (Server Patch Set) Symptoms: Related To:
• Wrong Results
• Database Link / Distributed
• ANSI Joins Description
A full outer join query with inline view executing remotely gets wrong result
missing rows when the inline view is merged.
Rediscovery Notes:
If a full outer join query is executed without native full outer join over a
database link and produces wrong results (missing rows) and the join involves
an inline view which is being merged then you may have encountered this bug.
Workaround
Use native full outer join or prevent the inline view from merging
by adding a NO_MERGE hint.
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
References
Bug:8432019 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
解决方案 »
- oracle解析xml实例增删改,自己收藏
- 批处理 txt文件导到 ORACLE数据库
- Incremental checkpoint
- oracle数据转移至sqlserver
- pl sql 调试oracle
- oracle 11g的SQLDevelop报12505错误,但是使用SQL*PLUS可以正常连接?
- trigger自动更新问题
- 创建的包带有编译错误,本人初学者能力低,找不到问题所在
- 请问:EXEC SQL SELECT ename, sal, NVL(comm, 0) INTO :emprec INDICATOR :emprec_ind FROM EMP中的INDICATOR是什么意义啊?
- oci里面能不能调用pl\sql啊? 能的话 给个例子吧
- 初学oracle?向各位高手求教?
- esql中怎么动态调用存储过程?
感觉Oracle现在咋水了呢
我之前遇到的几个问题还没找到原因呢
我目前的的解决方案是把通过DBLINK访问的表,每天同步到本地库里