Shrink Table: IEstimating Rollback Space
- From: Ian MacGregor <ian@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Oct 2008 13:52:48 -0700
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
- Follow-Ups:
- Re: Shrink Table: IEstimating Rollback Space
- From: rjamya
- Re: Shrink Table: IEstimating Rollback Space
- From: Hemant K Chitale
Other related posts:
- » Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » RE: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- » Re: Shrink Table: IEstimating Rollback Space
- Re: Shrink Table: IEstimating Rollback Space
- From: rjamya
- Re: Shrink Table: IEstimating Rollback Space
- From: Hemant K Chitale