ORA-01467: sort key too long error on oracle 10g

[aju1986]

Select ITEM.ITEM_NAME,
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.AVG_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.MIN_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.MAX_VALUE)),

Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.AVG_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.MIN_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.MAX_VALUE)) ,

Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.AVG_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.MIN_VALUE)),
Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.MAX_VALUE))
...
Max(...)
...

from ITEM, ANALYSIS, RESULT
where RESULT.ITEM_ID=ITEM.ITEM_ID
and  RESULT.ANALYSIS_ID=ANALYSIS.ANALYSIS_ID
Group by  ITEM.ITEM_NAME

[Luuk]

What is the definition of MFTR_NAME ?

But some googling found this link, which claims it's an Oracle 10 bug...