Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 17 Jul 2005 @ 11:26:29 GMT


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


Subj:   Re: Preventing TJ
 
From:   Victor Sokovin

  Is there a way we can prevent Transient journaling from happening for normal DMLs? Oracle has a alter table/tablespace .. nologging clause that prevents TJing (or redoing in oracle terms). Is such a facility available in TD? Pls clarify.  


I understand that Oracle NOLOGGING option does *not* actually apply to what I believe you might be calling "normal DMLs"! NOLOGGING applies only to a limited number of operations such as SQL*Loader direct loads, CREATE/ALTER INDEX, CREATE TABLE AS SELECT, reorganization of partitions etc.

"Usual" INSERT, UPDATE and DELETE statements will still be generating redo logs in the NOLOGGING mode. In this respect the situation is not that different from what we have in TD.


Regards,

Victor



     
  <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: 15 Jun 2023