Re: maximum number of columns per table

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 19 Jul 2004 22:28:50 -0700
Message-ID: <1090301352.683762@yasure>

Moritz Klein wrote:

> Hi NG,
> 5 minutes ago I ran into maximum number of columns per table exceeded. I
> found out that the limit is 1000 clumns per table on Oracle 9i. Is it
> possible to raise this number with the use of Database Initialization
> Parameters, or does upgrading to 10g provides any help on this? I read some
> posts about this limitation befor but they provide no solution to this. The
> Data-Model cannot/should not be changed.
>
> Any help appreciated
> Moritz
>

If you hit the limit this issue is not the limit but rather your design.

There is just about no excuse for having more than 50 columns in a table.

If you think otherwise I would suggest you take a class on relational database architecture and normalization.

Daniel Morgan Received on Tue Jul 20 2004 - 00:28:50 CDT