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

Disk usage for a materialized global temporary table is charged to the temporary space allocation of the user who referenced the table. Temporary space is reserved prior to spool space for any user defined with this characteristic.

If default temporary space is not defined for a database, then the space allocated for any materialized global temporary tables created in that database is set to the maximum temporary space allocated for its immediate owner.

n
Number of bytes to be allowed by default for creating global temporary tables by users within this database.
BYTES
Optional keyword that redundantly specifies the unit for the amount of space allowed.