Re: maximum number of columns per table

Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.19.13.39.02.998266_at_sbcglobal.net>...
> On Mon, 19 Jul 2004 14:55:41 +0200, 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.
>
> You can beat the limitation using nested tables. As far as for the
> database limits, they're in the Appendix A. of the reference manual.

I would be interested in learning more about the kind of domain/database design that requires 1000 columns in a table. I am just curious as to the application that needs to support this. Just imagine different applications/modules for update/delete/insert of a few columns each! Or even, from a human factors perspective, how would developer(s) deal with 1000 columns, remember them individually or their relationships to each other?

Could you please elaborate on the type of the application? While you noted that the design is not to be changed, there may be other ways to manage this in the future or in other projects. Received on Mon Jul 19 2004 - 16:22:30 CDT