Re: How many columns can one table have

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 2000/04/28
Message-ID: <39095578.1307964370@news.saix.net>#1/1

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

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

This does not make a lot of sense to me Sybrand. One of those strange Oracle phenomena... ;-)

255/256 does. This the max value that can be stored in a single byte (unsigned 8 bit : 0..255) - the assumption being of course that the size of the variable used to represent the column number is the limiting factor.

A 1000 columns.. If Oracle switched from a single byte value to a two byte integer value (an unsigned 16 bit word), then the max value is 65,535.

Any thought to why Oracle has selecting to impose artificial limits instead?

regards,
Billy Received on Fri Apr 28 2000 - 00:00:00 CDT