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
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
精彩评论