15.10 - SPOOL - 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)

Maximum space in bytes allowed for spool files for the specified user.

number
Integer, decimal, or floating point value.
constant_expression
A constant expression is any SQL expression that does not make any column references. Specifying an appropriate constant expression for the SPOOL space size of a user enables Teradata Database to assign an optimal quantity of spool that scales to the size of your system by allocating SPOOL space on a per AMP basis.
When you specify a SPOOL space size based on a constant expression, the assigned size does not automatically scale if, for example, you add more AMPs to your system.
BYTES
Optional keyword that redundantly specifies the unit for the amount of space allowed.