Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Error - 1467

Oracle Error - 1467

From: Ramasubramanian, Shankar (Cognizant) <RShankar1_at_CHN.COGNIZANT.COM>
Date: Wed, 30 Jan 2002 05:20:53 -0800
Message-ID: <F001.004003CC.20020130051025@fatcity.com>


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.com
Received on Wed Jan 30 2002 - 07:20:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US