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

The number of bytes to allocate for global temporary table space.

If no temporary space is defined in the profile assigned to a user, Teradata Database uses the setting defined for the individual user. Temporary space is reserved prior to spool space for any user defined with this characteristic. Disk usage for a materialized global temporary table is charged to the temporary space allocation of the user who referenced the table.

The default is NULL, which uses the setting defined for the individual user. Changes to the temporary space allocation in a profile take effect immediately upon submitting the MODIFY PROFILE request.

n
n can be an integer, a decimal value, or a floating point value.
n cannot exceed the temporary space parameter in the profile of the creator. If no temporary space limit is defined for that profile, then Teradata Database uses the temporary space limit defined for the individual user-creator.
n refers to bytes, whether or not the optional BYTES keyword is specified.
BYTES
Optional keyword.