15.10 - TEMPORARY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

Temporary space allowed for creating materialized global temporary tables by this user. Temporary space is reserved prior to spool space for any user defined with this characteristic.

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

Note that each materialized global temporary table requires a minimum of 512 bytes of PERM space to contain its table header.

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

n
Number of bytes allowed for creating materialized global temporary tables by this user.
BYTES
Optional keyword that redundantly specifies the unit for the amount of TEMPORARY space allowed.