Re: Rollback segments
From: Patrick Elliott <pelliott_at_isd.net>
Date: 1996/12/14
Message-ID: <32b27ecc.0_at_usamrid.isd.net>#1/1
Date: 1996/12/14
Message-ID: <32b27ecc.0_at_usamrid.isd.net>#1/1
chuckh_at_dvol.com (Chuck Hamilton) wrote:
>>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!
You also have to worry about foreign key constraints. If the table is referenced by any foreign keys, then they have to be disabled before a truncate is successful. Received on Sat Dec 14 1996 - 00:00:00 CET