Increase Column Limit in 23c Oracle database architecture

 

Hi All,

In this post i am going to share the one of the new Features in oracle database architecture .

### Increase Column Limit

The maximum number of columns allowed in a database table or view has been increased to 4096. This feature allows you to build applications that can store attributes in a single table with more than the previous 1000-column limit. Some applications, such as Machine Learning and streaming IoT application workloads, may require the use of de-normalized tables with more than 1000 columns.

You now have the ability to store a larger number of attributes in a single row which for some applications may simplify application design and implementation.

MAX_COLUMNS specifies the maximum number of columns allowed in database tables and views.

When this parameter is set to STANDARD, the maximum number of columns allowed in a database table or view is 1000.

When this parameter is set to EXTENDED, the maximum number of columns allowed in a database table or view is 4096.

The COMPATIBLE initialization parameter must be set to 23.0.0.0 or higher to set MAX_COLUMNS = EXTENDED.

You can change the value of MAX_COLUMNS from STANDARD to EXTENDED at any time. However, you can change the value of MAX_COLUMNS from EXTENDED to STANDARD only when all tables and views in the database have 1000 or fewer columns.

Note:

This parameter is available starting with Oracle Database 23c.

Thanks,

Srini