Database object size and number limitations [CR 403652]

The following corrections apply to Chapter 8, “Physical Limitations.”

• Database size: The maximum database size is approximately the number of files times the file size on a particular platform, depending on the maximum disk configuration. Refer to your operating system documentation for kernel parameters that affect the maximum number of files.

• Number of tables per database: 4,293,918,719

• Number of rows per table: 2⁴⁸

• Field size:

  • 255 bytes for BINARY, VARBINARY

  • 32,767 for CHAR, VARCHAR

  • Up to 512TB for 128KB pages or 1PB for 512KB pages for LONG BINARY, LONG VARCHAR