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 -> Re: ORA-00600: Index produces timeout ?

Re: ORA-00600: Index produces timeout ?

From: <nat_at_object-factory.com>
Date: Fri, 17 Apr 1998 07:02:16 -0600
Message-ID: <6h7gc6$g1a$1@nnrp1.dejanews.com>


In article <M26Z.1345$XG.15587728_at_harpo.ctel.net>,   "Ralph Button" <rbutton_at_ctel.net> wrote:
>
> We had the same problem and generated a TAR on it. It is a bug in 7.2
> If you have indexes on 2+ adjacent fields on a table you get the ol' 600
> error.
> We got a patch that upgraded 7.2.3. We also tried converting to 7.3.3 and
> the bug was gone there too.
>
> Ralph Button
> Dir. Technical Services
> Animated Images, Inc.
>

I think that's it. There are also a lot (too many IMO) of indexes on each table, which gives me problems. I will try to get a patch from Oracle until then, I'll just run with the primary key index.

Thanks a lot

        Nat!

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 17 1998 - 08:02:16 CDT

Original text of this message

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