Re: ORA-01467: sort key too long

HI +ACEAIQ-
if you want solv that problem..
 first you must check db+AF8-block+AF8-size +ACEAIQ-

Maybe your Database DB block size is too small +ACEAIQ-

You have to increase db+AF8-block+AF8-size (8k, 16k...)

        unfornatury you have to rebuild Instance+ACEAIQ-

You can solv That problem+ACEAIQ-

Good Luck+ACEAIQ-

    Danijel Stojnic +x3Q-(+rAA-) +ADw-88tkn8+ACQ-4jc+ACQ-1+AEA-pollux.ip-plus.net+AD4- +ulTC3MnAxdDBHA- +x5HBMdVYxgDCtbLIsuQ-...

    I have follow problem, when I make crosstable with more then 3 columns, I get the 'ORA-01467: sort key too long' Error.

    Anybody know how to solve this problem?

    SQL One:
    SELECT LANGUAGE+AF8-CODE+AF8-PK,

    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,1),'')) AS English,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,2),'')) AS French,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,3),'')) AS German

    FROM LANGUAGE+AF8-TEXT, LANGUAGE
    WHERE LANGUAGE+AF8-CODE+AF8-PK +AD0- LANGUAGE+AF8-CODE+AF8-FK     GROUP BY LANGUAGE+AF8-CODE+AF8-PK     SQL Two:
    SELECT LANGUAGE+AF8-CODE+AF8-PK,

    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,1),'')) AS English,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,2),'')) AS French,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,3),'')) AS German,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,4),'')) AS NewLang,
    min (DECODE(LANGUAGE+AF8-CODE+AF8-FK,LANGUAGE+AF8-CODE+AF8-FK,
TRNSLANG(LANGUAGE+AF8-CODE+AF8-FK,5),'')) AS Japanise

    FROM LANGUAGE+AF8-TEXT, LANGUAGE
    WHERE LANGUAGE+AF8-CODE+AF8-PK +AD0- LANGUAGE+AF8-CODE+AF8-FK     GROUP BY LANGUAGE+AF8-CODE+AF8-PK Received on Sun Feb 27 2000 - 19:57:00 CST