Re: 8i max columns

From: Corey Jackson <jackson_at_oafa.pitt.edu>
Date: Wed, 04 Apr 2001 08:44:46 -0400
Message-ID: <3ACB173E.37936F70@oafa.pitt.edu>

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
Received on Wed Apr 04 2001 - 07:44:46 CDT