Re: Delete without rollback?

Petri,

Have you tried TRUNCATE.

Bye,

Ronald

In article <4r81l3$4g1_at_kuikka.inet.fi>, <pjr_at_sip.fi> writes:
> Path:

news.pi.net!surfnet.nl!howland.reston.ans.net!gatech!news.mathworks.com!hunter. premier.net!uunet!inXS.uu.net!nntp.inet.fi!news.inet.fi!Digitronics
> From: pjr_at_sip.fi (Petri J. Riipinen)
> Newsgroups: comp.databases.oracle
> Subject: Delete without rollback?
> Date: Mon, 01 Jul 96 08:18:47 GMT
> Organization: Digitronics Ltd
> Lines: 14
> Message-ID: <4r81l3$4g1_at_kuikka.inet.fi>
> NNTP-Posting-Host: ppp6.sip.fi
> X-Newsreader: News Xpress 2.0 Beta #0
>
> Hi there.
>
> I have this one table, which I need to empty every now and then during my
> development. It's not too big, about 10000 rows. But when I do a complete
> delete (Delete * from mytable) it always fails and complains that the size of
> the rollback was exceeded (or something like that). Ok, I can understand
 that.
> But I wouldn't want to increase the size of the rollback-segment as this
> delete operation is not going to be used in production, just for my testing.
>
> So, is there a way to do a "permanent" delete at once, so that Oracle
 wouldn't
> use any space in the rollback-segment?
>
> Peace,
> Petri
>
Received on Sat Jul 13 1996 - 00:00:00 CEST