Archives of the TeradataForum
Message Posted: Fri, 23 Aug 2002 @ 08:21:46 GMT
The DBC.AllTempTables is for Global Temporary tables. The purely user local volatile tables are not put in that table.
one way would to track the use would to be have access logging turned on for the users for create table in their own database. then the accesslog will have the information stored, this will show details of how many users and tables were created in retrospect.
Another off the wall idea to track this, is to identify all users that are idle and if they have spool Then that point to the fact that they have a volatile table created in their spool allocation at present. You would have to grow your own processes for this by identifying users that are idle via PMON apis and use this idle list to look at current spool.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|