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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to sum up values into a 419(!!) columns wide Table

Re: How to sum up values into a 419(!!) columns wide Table

From: Thomas <echo88de_at_yahoo.de>
Date: 11 Dec 2006 08:38:42 -0800
Message-ID: <1165855122.892731.48840@16g2000cwy.googlegroups.com> 





Thanks a lot Charles for your help but after changing the whole
statement (with at least 1259 rows) to meet the conditions you answered
Oracle still refuses to execute the Statement with the mentioned
ORA-01467: sort key to long error.



Oracle/SQL_Plus sayed:



from t353x3_b.aggregation_table


              *


FEHLER in Zeile 1259:


ORA-01467: Sortierschlüssel zu lang


(ERROR in Row 1259:


ORA-01467: sort key too long)




Do you have another clue on how to solve this Prob ?



rgds Thomas
Received on Mon Dec 11 2006 - 10:38:42 CST












Original text of this message













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