Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Error - 1467
Hi Friends,
I am having a sql statement where
select field1,field2.. field15, sum(fieldx1), sum(fieldx2).. sum(fieldx200)
from t1
group by field1,field2.. field15;
when i execute this statement , i am getting error - 1467 which says sort key too long
Cause Mentioned in the document : 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.
My question is whether any restrictions on no of columns that can be grouped is there or is it depend on any space constraint on temporary tablespace..
Thanks in advance,
Shankar
This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information.If you are not
the intended recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or
copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.comReceived on Wed Jan 30 2002 - 07:20:53 CST