Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04167 Sort key too long
Hi
I am sure either you are trying to create the index by a parallel option or
while the table is being used by other users, specially being updated. This
is something similar to "Snapshot too Old" problem when oracle can not keep
a long enough read-consistant snapshot of the table to finish the job. If
you craete the index in restricted database mode I think it won't complain.
regards
reza
Eric DUCHET <eric.duchet_at_free.fr> wrote in message
news:Ibx%3.2378$Ey.11132086_at_nnrp1.proxad.net...
> Hi,
>
> I try to create an index on a non unique field VARCHAR2(13)
> and i've got the error message :
>
> create index DI_EVT_3 on EVENT(EVT_ITEMCODE) tablespace INDEX_1;
> ERROR at line 1:
> ORA-01467: sort key too long
>
> I have 1 000 000 rows in my table.
>
> What does mean this error ?
> Haow can I do to create my index ????
>
> Thanx
>
>
Received on Fri Nov 26 1999 - 09:52:13 CST