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

Home -> Community -> Usenet -> c.d.o.tools -> Rollback segments errors

Rollback segments errors

From: <barko_at_attglobal.net>
Date: Sat, 21 Oct 2000 23:50:43 -0400
Message-ID: <39f264fe_3@news1.prserv.net> 






I have been getting the following two errors when attempting to delete rows
from a fairly large table.



ORA-01623



ORA-01562


Both mention that the maximum number of extents (121) has been reached
during rollback.  To get around this I have to drop the table and reload it.



Any suggestions?



Chris
Received on Sat Oct 21 2000 - 22:50:43 CDT












Original text of this message













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