waht are different types of spaces in teradata?

There are three types of space with Teradata. They are:

• Perm Space,

• Spool Space, and

• Temp Space

"Perm space" defines the upper limit of space that a database or user can use to hold tables, secondary index sub-tables, and permanent journals

Spool space defines the upper limit of space that a user has to run a query. When a user runs a query, AMPs build the answer set in spool space. Once the query is done, the spool space is released. If the query exceeds the spool space's upper limit, the query aborts. Then, the user is out of spool space.

Temp space defines the upper limit that a user or database can have to hold Global Volatile Temporary tables.