Re: maximum number of columns per table

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.

-- 
A city is a large community where people are lonesome together.