15.10 - TEMPORARY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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

n
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
BYTES is an optional keyword that redundantly specifies the unit for the amount of TEMPORARY space
NULL
The default is NULL, which causes Teradata Database to use the setting defined for the user.