Re: Rollback segments

>You will have to increase the size of the rollback segment(s) (INITIAL
>and NEXT), but if you have to delete all data from the table, try using
>TRUNCATE TABLE...DROP STORAGE command instead of DELETE.

TRUNCATE is the better way. But if you have DELETE triggers on the table, they won't fire. Also TRUNCATE is considered DDL so there's no way to roll it back.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!