Re: 8i max columns

Your explanation makes me feel much better. Whew!

If you can't get your tool to code more columns you can either do it by hand ... Yech ... or just create multiple tables and then tie them together programmatically.

Daniel A. Morgan

Corey Jackson wrote:

> 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 Thu Apr 05 2001 - 02:00:36 CDT