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

Question

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

Answer 1

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