Teradata Vantage allows you to allocate several types of space:
Type | Description |
---|---|
Permanent space (perm space) | Stores data and database objects. Tables use the perm space owned by the containing database, as needed. Owners of perm space own any object that inhabits the space. |
Spool space | The space where database queries execute. By default, executing queries draw spool space from any unused system space. |
Temporary space (temp space) | Stores temporary tables and volatile tables. Allocation and use of temp space is optional. |
For more information, see space-related topics in Teradata Vantage⢠- Database Administration, B035-1093.