To Increase the Column Limit in 23c Oracle database
The One of the New Features of oracle database 23C.
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 table 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 21.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.
