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

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 11 Dec 2006 10:26:46 -0800
Message-ID: <1165861606.037723.299730@n67g2000cwd.googlegroups.com>

Thomas wrote:
> Hi Charles,
>
> It is a Table.
> I did your queries:
>
> OBJECT_NAME
> OBJECT_ID
> OBJECT_TYPE
> --------------------------------------------------------------------------------------------------------------------------------
> ---------- ------------------
> AGGREGATION_TABLE
> 100745
> TABLE
>
> For the secon no rows were selected...
>
> Yes I replaced the UNION with UNION ALL.
>
> rgds Thomas

Thanks - I wanted to make certain that AGGREGATION_TABLE was in fact a table and not a view. What is the db block size, and the version of Oracle: 8.1.7.4, 10.2.0.1, etc. Do any any of the columns that you are retrieving have the ability to hold more than 1999 bytes?

Take a look in Metalink at Note:18870.1, and Note:1012366.6 for tips to resolve this error. Both notes contain work arounds for this problem.

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