| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Error - 1467
Hmmm ... without actually referring to the manual, I think if the total size
of all the columns in the sort key is larger than one data block (minus some
overhead) you will get this error.
HTH
Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
[mailto:RShankar1_at_CHN.COGNIZANT.COM]
Sent: Wednesday, January 30, 2002 8:10 AM
To: Multiple recipients of list ORACLE-L
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
*********************************************************************2
This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.
*********************************************************************2
Received on Wed Jan 30 2002 - 07:36:24 CST
 |
 |