开发者

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

开发者 https://www.devze.com 2022-12-25 04:07 出处:网络
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?

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
0

精彩评论

暂无评论...
验证码 换一张
取 消