The maximum number of columns you can create in a table is:
1024 for fixed-length columns in both all-pages-locked (APL) and data-only-locked (DOL) tables
254 for variable-length columns in an APL table
1024 for variable-length columns in an DOL table
The maximum size of a column depends on:
Whether the table includes any variable- or fixed-length columns.
The logical page size of the database. For example, in a database with 2K logical pages, the maximum size of a column in an APL table can be as large as a single row, about 1962 bytes, less the row format overheads. Similarly, for a 4K page, the maximum size of a column in a APL table can be as large as 4010 bytes, less the row format overheads.
Item |
Version 12.0 limit |
Version 12.5 limit |
New range |
|---|---|---|---|
Number of logins per server (SUID) |
64K |
2 billion plus 32K |
-32768 to 2 billion |
Number of users per database |
48K |
2 billion less 1032193 |
-32768 to16383; 1048577 to 2 Billion |
Number of groups per database |
16K |
1032193 |
16384 to 1048576 |
