CODEWITHSUNDEEP
oracle-databasederby
Fazal
Fazal

Reputation: 3051

What is the limit on number of columns in Oracle 10G and Derby Databases

Until recently I thought limit on number of columns in Oracle DB was 255. But turns out the limit is 1000. Can someone confirm this?

Also I was trying to find if there is any similar limit on number of columns in Derby DB, particularly embedded derby java DB

Upvotes: 4

Views: 12911

Answers (1)

zendar
zendar

Reputation: 13572

Here's link to Oracle documentation: Logical Database Limits.
Excerpt:

Per table                           1000 columns maximum
Per index (or clustered index)        32 columns maximum
Per bitmapped index                   30 columns maximum


Here's link to Derby documentation: A Derby Database
Excerpt:

columns per table   1,012

Upvotes: 11

Related Questions