Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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).


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