Re: Problems Empty'in Tables

From: <denny_vk_at_hotmail.com>
Date: 1998/03/05
Message-ID: <6dm79u$j6d$1@nnrp1.dejanews.com>#1/1

Hi,

Thats because your rollback segment is small. Since you are trying to empty the table, try truncate table <tablename> instead. ( Note : You won't be able to rollback )

Denny

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 Thu Mar 05 1998 - 00:00:00 CST