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: max # of columns in the table (again!)

Re: max # of columns in the table (again!)

From: dias <ydias_at_hotmail.com>
Date: 15 Feb 2003 22:44:05 -0800
Message-ID: <55a68b47.0302152244.37694f38@posting.google.com>


Thank you all,

I agree, it's a design problem.

But I'm serching for arguments to prove that this design is bad.

I have to migrate data from an old application to Oracle, the database users, it's a DTWH, don't want to change the data model, and prefer to work with wide tables, rather than small ones whith joins.

Thanks.

ydias_at_hotmail.com (dias) wrote in message news:<55a68b47.0302142315.39934901_at_posting.google.com>...
> Hi,
>
> 1000 columns is the max for a table (8i and 9i).
>
> Oracle (8i) has an internal limit of 255. That means that if any
> columns beyond 255 are not null, that row will always be chained.
>
> Is this still the case in 9i ?
>
> Thanks
Received on Sun Feb 16 2003 - 00:44:05 CST

Original text of this message

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