Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Mon Jul 19 2004 - 08:39:03 CDT
![]() |
![]() |