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

Teradata Database Administration
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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)