From: Corey Jackson <jackson@oafa.pitt.edu>
Newsgroups: comp.databases.oracle.misc
Subject: Re: 8i max columns
Date: Wed, 04 Apr 2001 08:44:46 -0400
Organization: University of Pittsburgh
Lines: 22
Message-ID: <3ACB173E.37936F70@oafa.pitt.edu>
References: <3ACA1B4B.51640C69@oafa.pitt.edu> <3ACA4541.80BFFEBC@exesolutions.com>
NNTP-Posting-Host: oafa0027.oafa.pitt.edu
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en


I know it doesn't make sense, that's why I'm doing all this.  I'm developing a
system to replace our old, outdated one.  There are 2 tables with ~350 fields.
I wanted to import them as-is, then write programs to fill smaller and more
properly defined tables.

"Daniel A. Morgan" wrote:

> > I'm using Oracle 8i Personal Edition and I was using the Table Wizard to
> > try to create a table.  It stopped me at column 256.  Is that the max
> > allowed?  Is there any way around that?
>
> Excuse me ... but you've got to be kidding.
>
> There is no rational reason to define a table with 256 or more columns. In
> fact I would be seriously concerned about any table with 25 or more columns
> in a normalized database.
>
> My advise would be to not look for a workaround but rather to look for
> someone that can teach you how to normalize your schema.
>
> Daniel A. Morgan