sort key too long ???

From: benoit guyon <bguyon_at_polydeme.fr>
Date: 1 Sep 1999 16:22:13 GMT
Message-ID: <01bef49e$741584d0$1101a8c0@ouagadougou>

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." Received on Wed Sep 01 1999 - 11:22:13 CDT