Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: (RE): Calculating LIOs
Hmm...In my view, "today" is 9iR2. 10g is the day after tomorrow....;-) =
=20
I have not done much w/ 10g yet. We are just now getting to 9i on our = largest databases. (Roll out in prod is 8/21.) So, I don't see myself = doing anything ssignificant w/ 10g for at least another year.
But, it's good to know about these new features. Thanks Tanel!
-Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tanel P=F5der
Sent: Friday, August 13, 2004 1:29 PM
To: oracle-l_at_freelists.org
Subject: Re: (RE): Calculating LIOs
> old days, that meant export/import. Today, 'alter table table_a =
move;' =3D
> will do it. Note that if you do so, all indexes will be invalidated =
=3D
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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- 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:35:09 CDT
![]() |
![]() |