CODEWITHSUNDEEP
oracle-databasedatatable
Mani
Mani

Reputation: 741

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

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

Upvotes: 28

Views: 45279

Answers (3)

Danny Beckett
Danny Beckett

Reputation: 20748

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.

Upvotes: 41

Joby Wilson Mathews
Joby Wilson Mathews

Reputation: 11116

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

Upvotes: 3

mohamed sabri
mohamed sabri

Reputation: 71

for Oracle 11g :

1000 Columns per table

32 columns per index

Logical Database Limits:

https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits003.htm#i288032

Upvotes: 5

Related Questions