ORA-01467
sort key too long
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.
Action
Reduce the number of columns or group functions involved in the operation.