Shrink Table: IEstimating Rollback Space

From: Ian MacGregor <>
Date: Thu, 16 Oct 2008 13:52:48 -0700
Message-ID: <>

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

Received on Thu Oct 16 2008 - 15:52:48 CDT

Original text of this message