Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How many columns can one table have

Re: How many columns can one table have

From: GC <assistant_madman_at_hotmail.com>
Date: 2000/04/27
Message-ID: <39078E56.831EDEBA@hotmail.com>#1/1

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 Received on Thu Apr 27 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US