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

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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)