Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 13:06:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Thanks,

Vimala.

	<Prev	Next>		<<First	<Prev	Next>	Last>>