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 -> ORA-04167 Sort key too long

ORA-04167 Sort key too long

From: Eric DUCHET <eric.duchet_at_free.fr>
Date: Fri, 26 Nov 1999 14:55:36 GMT
Message-ID: <Ibx%3.2378$Ey.11132086@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 - 08:55:36 CST












Original text of this message













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