My Oracle Support Banner

23ai New Feature - Wide Tables (Doc ID 3063298.1)

Last updated on DECEMBER 24, 2024

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Oracle Database - Enterprise Edition - Version 23.4 and later
Oracle Database - Standard Edition - Version 23.4 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Information in this document applies to any platform.

Goal

The intent of this document is to introduce 23ai New Feature Wide Tables.

The maximum number of columns allowed in a database table or view has been increased to 4096 (Hidden columns and virtual columns are also included).
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.

Please also refer to the following online documentation for more details:

Oracle Database Release 23
Oracle Database New Features
Database Architecture
Wide Tables

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.