Re: 8i max columns

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Wed, 4 Apr 2001 16:57:37 +0200
Message-ID: <9afcpg$bpm$1@rex.ip-plus.net>

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 Wed Apr 04 2001 - 09:57:37 CDT