The space allocation of system user DBC is used for the following:
DBC Space | Purpose |
---|---|
PERM | Provides ownership of the Teradata production database space, which must accommodate the maximum PERM space allocated to each user and database by its creator. The allocated space is used to store the rows in the data tables created by each user, including the following items:
|
Creates and maintains the WAL log/transient journal, storing a before-image copy of every row affected by data changes in all current sessions and Redo and Undo WAL records. | |
Stores in the Data Dictionary the definitions for system tables, indexes, macros, triggers, and views. | |
Provides permanent space for the following:
|
|
TEMP | Provides temporary space for data inserted into materialized global temporary tables. |
SPOOL | Provides maximum defined SPOOL space to each user and database for the following uses:
|