Re: Problems Empty'in Tables

Correct! Truncate does not have a where option to it. It just EMPTIES your table, resets the HIGH WATER MARK and it is rather quick.

> -----Original Message-----
> From: MMSPENCE [SMTP:MMSPENCE_at_SOUTHERNCO.COM]
> Posted At: 04 March 1998 17:12
> Posted To: server
> Conversation: Problems Empty'in Tables
> Subject: 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