Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: (RE): Calculating LIOs
> old days, that meant export/import. Today, 'alter table table_a move;' =
> will do it. Note that if you do so, all indexes will be invalidated =
I couldn't resist again, but if "today" means Oracle 10g you can use "alter table shrink space cascade" (after you've allowed row movement on the table) which will compact both your table and it's indexes online and even lowers these segments HWM.
It doesn't lower index'es height though, this would get too complex to handle..
Tanel.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Aug 13 2004 - 12:25:09 CDT
![]() |
![]() |