Re: Problems Empty'in Tables

You have a few options here.
1) Increase the size of your rollback segments. 2) specify a specific rollback segment that is large enough to handle the delete. ie SET TRANSACTION USE ROLLBACK SEGMENT x 3) use multiple deletes with commits between them 4) use the truncate command. ie TRUNCATE TABLE x

Mark Powell wrote:
>
> 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 Tue Mar 03 1998 - 00:00:00 CST