Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: 8i max columns

Re: 8i max columns

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 03 Apr 2001 14:48:49 -0700
Message-ID: <3ACA4541.80BFFEBC@exesolutions.com>

> 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 Tue Apr 03 2001 - 16:48:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US