Re: Compressed Indexes fail

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Jan 2001 20:42:31 -0000
Message-ID: <980802024.4244.0.nnrp-14.9e984b29@news.demon.co.uk>

I have recently seen mention of a bug with compressed indexes in Metalink - can't remember the details but it might have been to do with queries that are index-only queries which this presumably is.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Mark Jenkins wrote in message ...


>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?

>

Received on Mon Jan 29 2001 - 14:42:31 CST