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