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.
