p; * Internal Error may occur (ORA-600)
* ORA-600 [qks3tinit] Related To: * DB-Link / Distributed
* Analytic SQL (Windowing etc..) Description ORA-600 [qks3tinit] possible from queries using ROLLUP which reference
remote objects. The full bug text (if published) can be seen at <Bug:2836690>
This link will not work for UNPUBLISHED bugs. 类似还有一个Bug： 文档 ID: 注释:2419335.8
主题: Support Description of Bug 2419335
类型: PATCH
状态: PUBLISHED
内容类型: TEXT/X-HTML
创建日期: 08-AUG-2003
上次修订日期: 14-AUG-2003
Click here for details of sections in this note.
Bug 2419335 OERI:[qks3tInit] possible from STAR transformation
This note gives a brief overview of bug 2419335.
Affects: Product (Component) Oracle Server (RDBMS)
Range of versions believed to be affected Versions >= 9.2 but < 10G
Versions confirmed as being affected * 9.2.0.3 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in * 9.2.0.4 (Server Patch Set)
* 10G Production Base Release Symptoms: * Internal Error may occur (ORA-600)
* ORA-600 [qks3tInit] Related To: * DB-Link / Distributed
* Star Transformation Description ORA-600 [qks3tInit] possible from star transformation query
where all the tables are remote (ie: over a dblink)
Workaround:
Set star_transformation_enabled = false at the remote DB. The full bug text (if published) can be seen at <Bug:2419335>
This link will not work for UNPUBLISHED bugs. 不过我还是觉得是TEMP TABLE TRANSFORMATION问题，没理由第2个SQL里的ROLLUP就没问题哦。唉，放弃ROLLUP咯。关于上面这个执行路径资料好少，有办法避免么？
上一页 [1] [2] | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 