Re: maximum number of columns per table

On Mon, 19 Jul 2004 14:55:41 +0200, "Moritz Klein" <mklein_at_students.uni-mainz.de> 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
>

As you currently have no serious data model, I don't see why it can't, indeed, why it shouldn't be changed. You don't have a normalized design right now now, and your database is mainly used as a garbage bin.

--
Sybrand Bakker, Senior Oracle DBA