16.10 - 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  ;