RE: syntax fro nologging on delete statemnt Oracle 8.1.7

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.

Regards,
Nelson

--
http://www.freelists.org/webpage/oracle-l