Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 18 Jul 2005 @ 08:59:30 GMT

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

Subj:   Re: Preventing TJ
From:   Victor Sokovin

  It does actually. If u alter a table to be nologging then no DMLs on that table are redo logged!! This is what I've seen. Pls point me to any sources you might have which says otherwise! Would be of much help to me!  

Sure. It does not seem hard to find the reference. For example, take a look at the manual entitled "Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02". The relevant section in it is "logging_clause". As far as proper DML statements are concerned, the restrictions are as follows:

"NOLOGGING is supported in only a subset of the clauses that support LOGGING. Only the following operations support the NOLOGGING mode:

Direct-path INSERT (serial or parallel)
Direct Loader (SQL*Loader) "

And then there are a few DDL operations mentioned such as CREATE TABLE AS SELECT etc.

Perhaps all the examples you have seen are of the "Direct-path INSERT (serial or parallel)" type? The latter strikes me as a rather special type of a DML statement. I for one would not refer to it as "normal DML".

Does this clarify the situation?



  <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: 28 Jun 2020