Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2012 @ 14:55:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

If spool is set at user level:

     SELECT databasename, SUM(maxspool)
        FROM dbc.diskspace
        WHERE databasename = USER GROUP BY 1;

Regards

Frank

	<Prev	Next>		<<First	<Prev	Next>	Last>>