RE: syntax fro nologging on delete statemnt Oracle 8.1.7

  • From: nelson.petersen@xxxxxxxxxxxxxxx
  • To: jdunn@xxxxxxxxx, Oracle-L@xxxxxxxxxxxxx
  • Date: Thu, 27 Jan 2005 09:24:41 -0500

What     does this not work?

delete from mytable where mytable.mynum = 20041212121212 nologging;

>>>  Try 
         DELETE FROM mytable NOLOGGING where ...;

Of course, you will want to read the manual.
Look for the section "SQL Statements That Can Use No-Logging Mode".
NOLOGGING will be ignored in the example you gave.



Other related posts: