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

Hello,

had been ill yesterday so sorry for that late answer at least the db_block_size = 8192
and the version is 9.2.0.0.0
To describe the structure of the table lets say the table has primary key consisting of three of those columns . (char(2)+number+char(29)). The other columns are columns of type number since the max width of number is 22 byte no column holds more than 1999bytes. Or do you mean as a sum total not more than 1999bytes?
Why 1999bytes?? Is there some kind of magical border?

Thanks

rgds, Thomas

On 11 Dez., 19:26, "Charles Hooper" <hooperc2..._at_yahoo.com> wrote:
> 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 ThomasThanks - 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 Wed Dec 13 2006 - 04:15:58 CST