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] [Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法 [聊天工具]小心Foxmail邮件模板BUG [聊天工具]OICQ---存在重大BUG? [系统软件]SQL语句性能优化--LECCO SQL Expert [系统软件]Windows记事本中的Bug [常用软件]解决压缩软件的Bug技巧 [C语言系列]SQL Server到DB2连接服务器的实现 [C语言系列]SQL Server到SYBASE连接服务器的实现 [C语言系列]SQL Server到SQLBASE连接服务器的实现
|