RE: (RE): Calculating LIOs
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Aug 2004 13:39:08 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tanel P=F5der
Sent: Friday, August 13, 2004 1:29 PM
To: oracle-l@xxxxxxxxxxxxx
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
