15.00 - BLOB, CLOB, XML, and Related Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

BLOB, CLOB, XML, and Related Limits

 

Parameter

Value

Maximum BLOB object size

2,097,088,000 8‑bit bytes

Maximum CLOB object size

  • 2,097,088,000 single‑byte characters
  • 1,048,544,000 double‑byte characters
  • Maximum XML object size

    2,097,088,000 8‑bit bytes

    Maximum number of LOB rows per rowkey per AMP for NoPI LOB or XML tables

    ~ 256M

    The exact number is 268,435,455 LOB or XML rows per rowkey per AMP.

    Maximum size of the file name passed to the AS DEFERRED BY NAME option in a USING request modifier

    VARCHAR(1024)