Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 13:06:40 GMT
The definitions of Global Temporary tables are stored in the dbc table 'tvm', where as the definitions of volatile tables are not stored in the data dictionary.
Volatile tables do not have a persistent definition unlike global temporary tables and must be created each time we need to use them. The table definition is cached only for the duration of the session in which it is created.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|