Re: Shrink Table: IEstimating Rollback Space

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.
Raj

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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
-----
Best regards
Rjamya

--
http://www.freelists.org/webpage/oracle-l