Re: Problems Empty'in Tables

From: Craig M. Wall <cwall_at_petersons.com>
Date: 1998/03/03
Message-ID: <6dhh8b$l0p@news9.noc.netcom.net>#1/1

Truncate the table or,
Shrink all other rollback segments to optimal and retry or, Slap another datafile on the RBS tablespace and retry or, Resize the default storage on the rollback segments and retry or, Delete just a few rows from the table at a time then commit, repeat, etc.

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