Increasing the Spool Space Limit for a User - Teradata Database

Specify a new value for SPOOL in a MODIFY PROFILE or MODIFY USER statement, depending on where the user spool is defined, for example:

MODIFY [PROFILE profile_name | USER user_name ] AS

SPOOL = bytes ;