Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> No logging during delete
Hi,
I am interested in knowing how to delete millions of records periodically from a table efficiently.
Can we use the nologging option on the table?
I am NOT looking for solutions which copy the records across a temporary table, truncating the original table, renaming etc.
Thanks,
Prasath.
Received on Wed Nov 16 2005 - 11:10:22 CST