Estimating Administrative TEMP Space Requirements - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Allocate the TEMP space required by the applications that support your enterprise to user SysAdmin.

Like PERM space, TEMP space is allocated from the available space of the owning user. Make an estimate of temporary space requirements.

With the TEMPORARY=n clause in the CREATE DATABASE and CREATE USER statements, you can specify the number of bytes to allocate to a database or user for creating global temporary tables. Temporary space is reserved before spool space for any user defined to have this attribute.

Disk usage for materialized global temporary tables is charged to the temporary space allocation of the user who referenced the table.

Global temporary tables also require a minimum of 512 bytes from the PERM space of the containing database or user. This space is used for the GTT table header.

If no temporary space is defined for a user, then the space allocated for any global temporary tables referenced by that user is set to the maximum temporary space allocated for the immediate owner.