Re: Shrink Table: IEstimating Rollback Space
- From: Ian MacGregor <ian@xxxxxxxxxxxxxxxxx>
- To: rjamya <rjamya@xxxxxxxxx>
- Date: Fri, 17 Oct 2008 05:42:44 -0700
Move requires rebuilding of the indexes. I¹m nrt sure it will be quicker.
Ian
On 10/16/08 6:46 PM, "rjamya" <rjamya@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> 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
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
Other related posts:
