Object File System Table Restrictions | VantageCloud Lake - Object File System Table Restrictions - Teradata VantageCloud Lake

Lake - Manage and Move Data

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-05-16
dita:mapPath
atx1683670417382.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
atx1683670417382
The following options are not supported for an Object File System table:
  • [UNIQUE] PRIMARY INDEX
  • [UNIQUE] INDEX
  • PRIMARY AMP
  • PRIMARY KEY
  • FOREIGN KEY
  • SET
  • GLOBAL TEMPORARY
  • VOLATILE
  • FALLBACK
  • JOURNAL
  • CHECKSUM, FREESPACE, MERGEBLOCKRATIO, DATABLOCKSIZE, BLOCKCOMPRESSION
  • ISOLATED LOADING
  • TEMPORAL
  • QUEUE
  • ERROR tables
  • PERMANENT JOURNAL
  • HARD RI
  • Multitable JOIN Indexes
  • Time series tables
The following load operations are not supported for an Object File System table. If attempted, an error is returned depending on the restriction.
  • FastLoad
  • MultiLoad
  • TPump
  • TPT load
  • TPT stream
  • TPT update