Re: sort key too long ???

From: <michael_bialik_at_my-deja.com>
Date: Thu, 02 Sep 1999 19:45:52 GMT
Message-ID: <7qmk5c$vj$1@nnrp1.deja.com>

Hi.

 Try following :

 SELECT KEY, F01, F02,..., F10
 FROM footable
 WHERE cond1 or cond2;

 If you still going the same error, try another approach :

 SELECT tt.KEY, t1.F01, t1.F2,..., t1.F10  FROM footable t1, ( select key from footable x1 where cond1 union

                     select key from footable x1 where cond2 ) tt

 WHERE t1.key = tt.key

 Good luck. Michael.

In article <01bef49e$741584d0$1101a8c0_at_ouagadougou>,   "benoit guyon" <bguyon_at_polydeme.fr> wrote:
> hello
> i have a ORA-01467 : sort key too long when execute :
>
> --**************************************************
> select key, column1, ...., column10
> from footable
> where cond1
>
> UNION
>
> select key, column1, ...., column10
> from footable
> where cond2
> --**************************************************
>
> with column1, , column10 varchar2(4000) full of data
> this error is due to the DISTINCT operation that is made for the UNION
> operation
>
> my question is :
> -- how to enlarge the sort key :) (ora.ini ?)
> -- how to make that the DISTINCT operation uses the key of the row
instead
> of the all values of the row
> thanks in advance
>
> guyon benoit -- bguyon_at_polydeme.fr
> société polydeme -- http://www.polydeme.fr
> Salut ! Je suis un virus de signature :) Mettez-moi dans la vôtre.
> "Any technology distinguishable from magic is insufficiently
advanced."
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 02 1999 - 14:45:52 CDT