15.10 - TEMPORARY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

A keyword allowing you to define how much space to allow for creating materialized global temporary tables.

n cannot exceed the temporary space parameter in the profile of the creator.
n can be an integer, a decimal value, or a floating point value.
n refers to bytes, whether or not the optional BYTES keyword is specified.
If no temporary space limit is defined for the profile, the system uses the temporary space limit defined for the individual user. If temporary space is not defined for either the profile or user, the system uses the temporary space limit for the owner of the space in which the user was created.
If both space allocations are defined, temporary space is reserved prior to spool space.
Disk usage for a materialized global temporary table is charged to the temporary space allocation of the user who referenced the table.
BYTES is an optional keyword that redundantly specifies the unit for the amount of TEMPORARY space
The default is NULL, which causes Teradata Database to use the setting defined for the user.