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

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 11 Dec 2006 09:30:37 -0800
Message-ID: <1165858237.264195.263810@16g2000cwy.googlegroups.com>

Thomas wrote:
> 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

Is AGGREGATION_TABLE a view, or is it a table? Please post the results of this SQL statement:
SELECT

  OBJECT_NAME,
  OBJECT_ID,
  OBJECT_TYPE

FROM
  DBA_OBJECTS
WHERE
  OBJECT_NAME='AGGREGATION_TABLE'; And also the results of this:
SELECT
  TEXT
FROM
  USER_VIEWS
WHERE
  VIEW_NAME='AGGREGATION_TABLE'; Did you replace "UNION" with "UNION ALL" in your query?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Dec 11 2006 - 11:30:37 CST