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:

DML:
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?

Regards,

Victor


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

Attachments

Library

Quick Reference