Re: Shrink Table: IEstimating Rollback Space
Date: Thu, 16 Oct 2008 21:46:58 -0400
i haven't see a formula but there is a metalink note that says for larger tables ' alter table move' might be better since shrink is insert (in the beginning) and delete (from tail end) operation and hence takes longer and generated more redo.
On Thu, Oct 16, 2008 at 4:52 PM, Ian MacGregor <ian_at_slac.stanford.edu>wrote:
> I have a 450 GB table with 150 GB of free space. I'd like to shrink the
> table, but I'm not sure how much rollback will be needed. Is there a
> formula? One that accounts for the indexes as well?
> Ian MacGregor
> SLAC National Accelerator Laboratory
-- ----- Best regards Rjamya -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2008 - 20:46:58 CDT