Re: ORA-04167 Sort key too long

From: Stefan Rudolph-Klindtwort <StefanRudolph-Klindtwort_at_t-online.de>
Date: Fri, 26 Nov 1999 16:19:26 +0100
Message-ID: <81m8ap$4bo$1@news07.btx.dtag.de>

Hello

that's the meaning of your error :

ORA-01467 sort key too long

Cause: A DISTINCT, GROUP BY, ORDER BY, or SET operation requires a sort key longer than that supported by Oracle. Either too many columns or too many group functions were specified in the SELECT statement.

Action: Reduce the number of columns or group functions involved in the operation.

That seems not to be very helpfull if your table have 1.000.000 Cols !

Sorry, hope to help you ....

Eric DUCHET <eric.duchet_at_free.fr> schrieb in im Newsbeitrag: 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:19:26 CST