Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Feb 2003 @ 20:14:27 GMT


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


Subj:   Re: Volatile vs. Global
 
From:   Dieter Nöth

Anomy Anom wrote:

  Another difference may be in the use of transient journaling. Volatile tables do not (I believe) use TJ. I do not know about Global. Can anyone can correct my info?  



Both use TJ unless you specify the NO LOG option.

Other differences: Global temp tables are typically created in a shared database by administrative users and not by end users.

But an end user can create a volatile table even if he has no perm (space but still needs the Create Table right).


Dieter



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016