What is the maximum number of columns allowed in a table?

Question

What is the maximum number of columns allowed in an Oracle table, in the following versions?

This should be covered in the respective documentation under the "limits" (or equivalent) section: -1 because this information should be gleaned from the official references. — , Feb 06 '13 at 06:27

Danny Beckett · Accepted Answer · 2020-08-13T18:09:52.777

40

A limit of 1,000 columns per table applies for versions 8i, 9i, 10g, 11g, 12c, 18c and 19c.

Prior to that, Oracle 7 had a 254 column limit.

edited Aug 13 '20 at 18:09

answered Feb 06 '13 at 06:27

Danny Beckett

score 5 · Answer 2 · answered Jun 30 '15 at 07:27

5

for Oracle 11g :

1000 Columns per table

32 columns per index

Logical Database Limits:

answered Jun 30 '15 at 07:27

mohamed sabri

score 3 · Answer 3 · answered May 30 '16 at 06:41

3

For version 11g,10g,9i and 8i column size:-

Per table:1000 columns maximum

Per index (or clustered index):32 columns maximum

Per bitmapped index:30 columns maximum

answered May 30 '16 at 06:41

3 Answers3