Re: Problems Empty'in Tables

I don't see a 'where' clause. Can you just truncate the table instead of deleting? Then you won't have any rollback problems.

posani_at_hotmail.com wrote in article <6diljb$4oc$1_at_nnrp1.dejanews.com>...
> 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 Wed Mar 04 1998 - 00:00:00 CST