Archives of the TeradataForum
Message Posted: Wed, 24 Feb 2010 @ 16:32:04 GMT
| Subj: | | Re: Question about where in dbc volatile tables are |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, February 24, 2010 11:24 -->
Hi,
Please, regarding these comments:
| | Don't believe you'll find any reference to Volatile table definitions > in DBC tables. There is no DD/DS definition - they only exist for
the user (TEMP SPACE) for the session they're created in. You are > referring to VOLATILE TEMPORARY tables > - right? | |
| | Any user that has TEMP space assigned to their userid can create a VOLATILE TEMPORARY table - but as soon as that session ends - it will
disappear. Even for the time it was materialized for - there is no DD/DS entry - it's all memory!" | |
These are in part wrong statements, when they refer to space utilization, confusing VOLATILE and GLOBAL temporary tables.
The user does not need TEMP space to create a volatile table in her/his session, only SPOOL space is needed to materialize it.
TEMP space is required to create an instance of a GLOBAL temporary table.
Thank you.
| 
