Re: Delete without rollback?
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