Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Fri, 14 May 2004 @ 19:28:36 GMT





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




Subj:   Re: Global Temp Table Dumb Question
 
From:   Fred W Pluebell



Not a dumb question at all.

There is an empty "template" table defined in database D's PERM space when you do the CREATE GLOBAL TEMPORARY TABLE D.X ...

When user A references that table, an instance (local to the session) is materialized and charged against user A's TEMP space.





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008