Oracle database error code ORA-01467 – sort key too long

Oracle Database Error Code ORA-1467 Description :
sort key too long
Error 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.

How to Solve :
Reduce the number of columns or group functions involved in the operation.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»