Re: online space reorgs in 8i
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: kylelf@xxxxxxxxx
- Date: Tue, 30 Jun 2009 10:56:04 -0500
Quest did a live reorg by taking advantage of partitioning in some way. I
used live reorg for a while, but did not like it. It was way too error
prone. I ended doing the reorgs manually. My experience is that tables
generally dont need to be rebuilt, but that indexes subject too both range
scans and frequent deletes will need to be rebuilt periodically.
On Tue, Jun 30, 2009 at 10:39 AM, kyle Hailey <kylelf@xxxxxxxxx> wrote:
>
> Anyone know how Quest or Platinum did a live reorg in Oracle 8?
> Working with some folks in China who really want to reorg on 8, can't
> upgrade for down time etc.
> They are convinced they need reorgs.
> I'm trying to figure out if they really need reorgs or not but the
> communication is spotty.
>
> In the mean time I'm trying to see if we can do any live reorgs on 8.
>
>
> Thanks
> Kyle
> http://oraclemonitor.com
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
