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

Home -> Community -> Usenet -> c.d.o.tools -> Compressed Indexes fail

Compressed Indexes fail

From: Mark Jenkins <markj_at_pcsincnet.com>
Date: Sun, 28 Jan 2001 23:12:33 -0600
Message-ID: <B69A57E0.2CC92%markj@pcsincnet.com>

If we use the default compressed indexes, we get the following error:

ORA-00600: internal error code, arguments: [12421], [], [], [], [], [], [], []
Current SQL statement for this session:
select count(*) from f_event where eventDate ='22-jan-2001' and eventtype_key='1'

If we alter the indexes to NOCOMPRESS everything works fine.

Is this a known problem/bug?

Oracle 8.1.7 / Solaris 8

Thanks

-- 
Mark Jenkins
Professional Computer Services, Inc.
Beloit, WI
markj_at_pcsincnet.com
http://www.pcsincnet.com/
Received on Sun Jan 28 2001 - 23:12:33 CST

Original text of this message

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