Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No logging during delete

Re: No logging during delete

From: Eagle Fan <eagle.f_at_gmail.com>
Date: 17 Nov 2005 06:20:56 -0800
Message-ID: <1132237255.980389.190710@g43g2000cwa.googlegroups.com> 





Nologging will not help you for your case. Delete operation always need
to log the redo.



You can consider partition table. It needs you to change the table
definition but it will be very efficiently in the future.



Or you can test bulk delete, which you can used without table
definition changing.
Received on Thu Nov 17 2005 - 08:20:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US