|
|
Archives of the TeradataForum
Message Posted: Sun, 17 Jul 2005 @ 11:26:29 GMT
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
| |