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 -> max # of columns in the table (again!)

max # of columns in the table (again!)

From: dias <ydias_at_hotmail.com>
Date: 14 Feb 2003 23:15:58 -0800
Message-ID: <55a68b47.0302142315.39934901@posting.google.com>


Hi,

1000 columns is the max for a table (8i and 9i).

Oracle (8i) has an internal limit of 255. That means that if any columns beyond 255 are not null, that row will always be chained.

Is this still the case in 9i ?

Thanks Received on Sat Feb 15 2003 - 01:15:58 CST

Original text of this message

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