Re: Delete without rollback?

In article <4r81l3$4g1_at_kuikka.inet.fi>, "Petri J. Riipinen" <pjr_at_sip.fi> 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

Try TRUNCATE TABLE table_name;

-- 
Chris