Re: Shrink Table: IEstimating Rollback Space

Move requires rebuilding of the indexes. I¹m nrt sure it will be quicker. Ian

On 10/16/08 6:46 PM, "rjamya" <rjamya_at_gmail.com> wrote:

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

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