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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008