Re: Anybody have experience of online reorg tools ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: 9 May 2003 00:41:01 -0700
Message-ID: <190d457f.0305082341.257338a8@posting.google.com>

Hi Antoine,

I appreciate the functions availble, but having a gui/client/server tool would still be easier to manage.
Thanks,

Neil.

"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 Fri May 09 2003 - 02:41:01 CDT