Re: Delete without rollback?

From: Steve Dodsworth] <Steven_Dodsworth_at_qsp.co.uk>
Date: 1996/07/01
Message-ID: <4r82u6$564_at_mailhost.qsp.co.uk>#1/1


In <4r81l3$4g1_at_kuikka.inet.fi>, pjr_at_sip.fi (Petri J. Riipinen) writes:
>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
>

Petri,

If you want to remove ALL of the rows ALL of the time use 'truncate'

Bye,

Steve

opinions expressed are mine and do not
necessarily represent those of my employer Received on Mon Jul 01 1996 - 00:00:00 CEST

Original text of this message