Re: How many columns can one table have

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/27
Message-ID: <956812024.11864.0.pluto.d4ee154e@news.demon.nl>#1/1

GC <assistant_madman_at_hotmail.com> schreef in berichtnieuws 39078E56.831EDEBA_at_hotmail.com...
> default wrote:
> >
> > I am ding some trend analysis from orcale 6, 7, 8, and find out how many
> > columns can one table hold (max)
>
> I believe with 32 bit Oracle, the maximum is 254 (or 255 or 256 -
> somewhere around there - I'm not currently at $PLACE_OF_WORK, so I
> cannot check the table). However, this limitation does not exist in the
> 64 bit version of Oracle.
>
> Cheers,
> GC

Untrue,

the maximum number is 254 in Oracle 6 and 7, and 1000 in Oracle 8, regardless of 32 or 64 bit

Sybrand Bakker, Oracle DBA Received on Thu Apr 27 2000 - 00:00:00 CDT