Re: Problems Empty'in Tables

You need to do one of two things:

1. delete a certain number of rows, say 20, and then commit after each batch of 20. This frees up rollback which is being used when you are deleting.
2. alternatively, increase the size of your rollback tablespace. It would also help to check the size of the next extent the rb segment is going to take and increase this to ensure you don't run out of extents.

Vince Currie

Mark Powell <markp_at_tsm.u-net.com> wrote in article <01bd46c4$7f4b0840$e78177c2_at_exhibit.u-net.com>...
> Hi,
>
> Just trying to empty a table and get the following error message :-
>
> SQL> delete unetuser.e_cust;
> delete unetuser.e_cust
> *
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 4
> ORA-01650: unable to extend rollback segment R03 by 64 in tablespace RBS
>
>
> SQL>
>
> *Bewildered*, any ideas?
>
> Thanks,
>
> Mark Powell
>
Received on Thu Mar 05 1998 - 00:00:00 CST