Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA ERROR 1467
"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