From: "Ian Ledzion" <ian.ledzion@lgxbow.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: 8i max columns
Date: Wed, 4 Apr 2001 16:57:37 +0200
Organization: Remove the x from domain
Lines: 27
Message-ID: <9afcpg$bpm$1@rex.ip-plus.net>
References: <3ACA1B4B.51640C69@oafa.pitt.edu> <YKsy6.610$4e.171909@newshog.newsread.com>
NNTP-Posting-Host: 195.65.96.34
X-Trace: rex.ip-plus.net 986396272 12086 195.65.96.34 (4 Apr 2001 14:57:52 GMT)
X-Complaints-To: abuse@ip-plus.net
NNTP-Posting-Date: Wed, 4 Apr 2001 14:57:52 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700


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@bestweb.net> wrote in message
news:YKsy6.610$4e.171909@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@oafa.pitt.edu> wrote in message
> news:3ACA1B4B.51640C69@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
> >
>
>