Re: 8i max columns

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 05 Apr 2001 00:05:26 -0700
Message-ID: <3ACC1936.A76BA506@exesolutions.com>

I'll disagree for the reason noted above. What you have is sparse data. 90+ out of 100 columns are null. Or something like that. Think vertically ... not horizontally.

Daniel A. Morgan

Ian Ledzion wrote:

> Actually we're nearing 100 on a financial application where you store
> instruments (bonds, shares, options, etc) in one table. This is normalised
> as all operations refer to some kind of instrument.
>
> "Van Messner" <vmessner_at_bestweb.net> wrote in message
> news:YKsy6.610$4e.171909_at_newshog.newsread.com...
> > Tables can have 1000 columns but Oracle stores them as three sections of
255
> > columns and one section of 235 columns. Perhaps the table creation wizard
> > stumbles in a case like this.
> >
> > Van
> >
> >
> > "Corey Jackson" <jackson_at_oafa.pitt.edu> wrote in message
> > news:3ACA1B4B.51640C69_at_oafa.pitt.edu...
> > > 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?
> > >
> > > Thanks
> > > Corey
> > >
> >
> >
Received on Thu Apr 05 2001 - 02:05:26 CDT