Shrink Table: IEstimating Rollback Space

From: Ian MacGregor <ian_at_slac.stanford.edu>
Date: Thu, 16 Oct 2008 13:52:48 -0700
Message-ID: <C51CF7B0.124B3%ian@slac.stanford.edu>

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

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

This message: [ Message body ]
Next message: Bradd Piontek: "Re: Memory issue with Oracle 10g database on Sun Server T5140 with Solaris 10"
Previous message: Sandra Becker: "Re: Problem with DBTIMEZONE"
Next in thread: rjamya: "Re: Shrink Table: IEstimating Rollback Space"
Reply: rjamya: "Re: Shrink Table: IEstimating Rollback Space"
Reply: Hemant K Chitale: "Re: Shrink Table: IEstimating Rollback Space"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message