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

Home -> Community -> Usenet -> c.d.o.misc -> rollback segment not big enough

rollback segment not big enough

From: Zoran Kukoljac <zorank_at_home.com>
Date: Thu, 08 Oct 1998 23:50:18 GMT
Message-ID: <361DF8CC.C007650@home.com> 





Hi,


I am truing to delete  a large number of row from one database table but
the statement fails with message:


"failed to extend rollback segment"


Is it possible to "turn off" rollback feature only for one statement or
session or to tell oracle to automatically commit after for example
every 100 deleted rows ?



Thanks, Zoran



Received on Thu Oct 08 1998 - 18:50:18 CDT












Original text of this message













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