Bug 2361148

感谢tony！

环境：9201+WinXP

执行下一句SQL报ora-600

SQL> select substr(sys_connect_by_path(tns_field,','),2)

from (select rownum rn ,rownum - 1 rn2,tns_field from tb_tnsrule@kyblsw )

where level = 80

start with rn = 1

connect by prior rn = rn2;

from (

select rownum rn ,rownum - 1 rn2,tns_field from tb_tnsrule@kyblsw )

*ERROR 位于第 2 行: ORA-00600: 内部错误代码，参数: [qerrmOFBu1], [1489], [], [], [], [], [], []

查metalink得知：

Bug 2361148

Fixed: 9.0.1.4, 9.2.0.2, 10.1.0.2

ITPub博客

一条SQL导致的ora-600 代码