Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems Empty'in Tables
This message is due to the size of the rollback segment. to overcome this problem increase the size of rollback segment or better you create a big temorary rollback segment and set transaction to the newly create rollback segment and use delete statemt . This will solve your problem.
posani suresh
In article <01bd46c4$7f4b0840$e78177c2_at_exhibit.u-net.com>,
"Mark Powell" <markp_at_tsm.u-net.com> 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
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 03 1998 - 00:00:00 CST