Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00600 when selecting

ORA-00600 when selecting

From: <gplagge_at_hotmail.com>
Date: Wed, 05 Aug 1998 00:02:00 GMT
Message-ID: <6q87do$jbt$1@nnrp1.dejanews.com>


Hi,
We are running Oracle 8.0.4.1.3 on NT 4.0.

The following queries cause the infamous ORA-00600 errors:

SQL> select /*+ full(ut_captures) parallel(ut_captures) */ count(*)   2 from ut_captures;
ERROR:
ORA-00600: internal error code, arguments: [15833], [], [], [], [], [], [], []

SQL> select count(*) from ut_capt_par partition (ut_sep1998); select count(*) from ut_capt_par partition (ut_sep1998)

                     *

ERROR at line 1:
ORA-00600: internal error code, arguments: [qkaffsindex4], [], [], [], [], [], [], []

Either will complete correctly with a simple where clause (like where 1 = 1)

Has anyone else run into these?

(I have entered TARs with Oracle Support...)

Thanks for the help,

Gene Plagge
WorldxChange, Inc.
gplagge_at_hotmail.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 19:02:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US