Re: ORA ERROR 1467

From: Hieraklion <hieraklion_at_spray.fr>
Date: Fri, 17 Aug 2001 15:33:31 +0200
Message-ID: <3B7D1D2B.9202E036@spray.fr>

"Bonjour" from Paris,

There is a bug (487957) where an index can become corrupted under heavy concurrency and one of the symptoms is encountering an ORA-1467 during a rebuild attempt.

The bug is fixed in Oracle8 and was also included in the 7.3.4.2 patchset release. Even though you are on 7.3.4.4, it is possible that you encountered this bug at an
earlier time if the index was created prior to 7.3.4.2. The only workaround if you have encountered this bug is to drop and recreate the index. You should not experience this error on any further rebuild attempts.

"Au revoir" from Paris
Christophe Brault

magi a écrit :

> Hi all,
>
> While rebulding one index i got an error ORA-01467. Sort Key too long.
> What is this error ? Is drop and recreate the only way to eliminate this?
> i am using Oracle 7.3.4 on AIX.
>
> thanks
>
> magi
Received on Fri Aug 17 2001 - 08:33:31 CDT