Re: Rollback segments
From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/12/13
Message-ID: <32b3698a.4532191_at_n5.gbso.net>#1/1
Date: 1996/12/13
Message-ID: <32b3698a.4532191_at_n5.gbso.net>#1/1
>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.
[Quoted] 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 [Quoted] This message delivered by electronic sled dogs. WOOF!Received on Fri Dec 13 1996 - 00:00:00 CET