Delete without rollback?

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 Mon Jul 01 1996 - 00:00:00 CEST