Re: Table columns
Date: Wed, 18 Apr 2001 23:59:36 GMT
Message-ID: <ITpD6.27377$xN4.1926178_at_news1.sttls1.wa.home.com>
You can have 1000 columns in a table. However, Oracle stores that as 3 rows
of 255 each (okay the last one is not 255) so really 255 columns is probably
the best choice to prevent chaining.
Jim
<pudidog15_at_icubed.com> wrote in message news:9bkpqs$efl$1_at_news.netmar.com...
> What is the "practical" limit for the number of columns on a table? Assume
> table will hold several million records of mostly varchar data.
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net
Received on Thu Apr 19 2001 - 01:59:36 CEST