RE: Oracle Error - 1467

From: <G.Plivna_at_itsystems.lv>
Date: Thu, 31 Jan 2002 06:49:57 -0800
Message-ID: <F001.00401E36.20020131053533@fatcity.com>

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=18870.1 explains that rather well

Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/

                                                                                       
                                  
                    "Jamadagni,                                                        
                                  
                    Rajendra"                 To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <Rajendra.Jamadagni       cc:                                      
                                  
                    @espn.com>                Subject:     RE: Oracle Error - 1467     
                                  
                    Sent by:                                                           
                                  
                    root_at_fatcity.com                                                   
                                  
                                                                                       
                                  
                                                                                       
                                  
                    2002.01.30 15:30                                                   
                                  
                    Please respond to                                                  
                                  
                    ORACLE-L                                                           
                                  
                                                                                       
                                  
                                                                                       
                                  

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

---

Rajendra Jamadagni                  MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

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
(See attached file: ESPN_Disclaimer.txt)

=?Windows-1257?Q?ESPN=5FDisclaimer.txt?= Description: Binary data

Received on Thu Jan 31 2002 - 08:49:57 CST