Menu
What is the maximum number of columns allowed in an Oracle table, in the following versions?
902
To find the max value of a column, use the MAX() aggregate function; it takes as its argument the name of the column for which you want to find the maximum value. If you have not specified any other columns in the SELECT clause, the maximum will be calculated for all records in the table.
There's a hard limit of 1,000 columns per table in Oracle Database. So you have to split it into many tables. But if you split it into many tables each with <= 255 columns, you'll have more joins.
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.
188
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
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
