Re: Problems Empty'in Tables

From: Chris Colclough <chris.colclough_at_nospam.jhuapl.edu>
Date: 1998/03/03
Message-ID: <34FC4A00.24CBDED9@nospam.jhuapl.edu>#1/1

Sure...the table has more data then the rollback segs can handle. The easy solution is:
truncate table unetuser.e_cust

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