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 -> How to disable rollback

How to disable rollback

From: Boris Bliznukov <blib_at_dnm.it>
Date: Wed, 27 Oct 1999 16:20:37 +0400
Message-ID: <3816EE15.DDEB302D@dnm.it> 





Hi All!



Is there any way to disable rollback?



I have a table with ~ 3M rows and ~ 2G size and I want to delete about
1M rows at once ... Rollback segment was overflowing so I extend it :)
... now delete is running for straight 4 hours ... no luck so far ... 



Is it possible at all? 



--


*** "I think there is a world market for maybe five computers."
*** Thomas Watson, chairman of IBM, 1943
Received on Wed Oct 27 1999 - 07:20:37 CDT












Original text of this message













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