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]