Re: Anybody have experience of online reorg tools ?

From: Antoine BRUNEL <antoinebrunel/yahoo.fr>
Date: Fri, 9 May 2003 02:39:59 +0200
Message-ID: <3ebaf8e0$0$7947$79c14f64@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 - 19:39:59 CDT