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.
Regards,
Nelson
--
//www.freelists.org/webpage/oracle-l
Other related posts:
