From: "Craig M. Wall" <cwall@petersons.com>
Subject: Re: Problems Empty'in Tables
Date: 1998/03/03
Message-ID: <6dhh8b$l0p@news9.noc.netcom.net>#1/1
References: <01bd46c4$7f4b0840$e78177c2@exhibit.u-net.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Netcom
X-NETCOM-Date: Tue Mar 03 12:13:31 PM CST 1998
Newsgroups: comp.databases.oracle.server



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@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