Also ask yourself why are you doing this? Measure the performance before
and after and see if it really made a difference.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message
news:3ebaf8e0$0$7947$79c14f64_at_nan-newsreader-01.noos.net...
> Beginning with 8i, and even mostly with 9i, you are now able to move
objects
> without altering their availabity:
>
> alter table XX move....
> alter index XXX rebuild ...
>
> theses SQL can be parallelized (degree X), nologging.
>
> In 92, there are packages specific for online table reorg.
>
>
>
> "Neil Cudd" <neil_at_cudd.demon.co.uk> a écrit dans le message de
> news:190d457f.0305081632.4a38cbec_at_posting.google.com...
> > I'm to make recommendations and was wondering if anybody out there has
> > experience of an online reorg tools and would care to share their
> > experiences.
> >
> > My platform is primarily 9i 64bit on aix 5.1 - SAP systems.
> >
> > Any pointers gratefully received.
> >
> > Thanks,
> >
> > Neil.
>
>
Received on Thu May 08 2003 - 21:00:39 CDT
