Re: Rollback segments errors

You can try:

- increase the maximum number of extents in rollback (500 or more),
- create your own big rollback segment and use it in transaction,
- delete rows in cycle 1000-2000 each with commit;
- create partitioned table.

<barko_at_attglobal.net> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:39f264fe_3_at_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 Mon Oct 23 2000 - 00:55:39 CDT