Thanks for the pointer. I was planning on shrinking the indexes separately. It doesn't look like the shrink will be possible. Ian On 10/17/08 7:47 AM, "Hemant K Chitale" <hkchital@xxxxxxxxxxxxxx> wrote: > > Undo (and Redo !) will be quite noticeable-- more so as you have > indexes on the table. > > A SHRINK operates as a DELETE (which will be the very significant > portion of Undo) *and* an INSERT. > Both operations also have to update Indexes . > The Indexes will not shrink until and unless you do a COALESCE or REBUILD. > > See MetaLink Note#577375.1 and Bug# 3888229. > > Hemant K Chitale > > At 04:52 AM Friday, Ian MacGregor 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 > > > Hemant K Chitale > http://hemantoracledba.blogspot.com > > "A 'No' uttered from the deepest conviction is better than a 'Yes' > merely uttered to please, or worse, to avoid trouble." > Mohandas Gandhi Quotes > : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html > -- //www.freelists.org/webpage/oracle-l