Re: Alter index xxx rebuild partitions

chan01 wrote:

> This is partition table with local indexe. The index is logging mode.
> When we are rebuilding the index can we use the paralle option?
>
> DA Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3E85DA2E.A894527F_at_exxesolutions.com>...
> > chan01 wrote:
> >
> > > i would like to know how much time app. it will take
> > > alter index xxx rebuild partition ix_jun02.
> > > i did for 5 GB data partition it took me 73 minutes.
> > >
> > > I am using SunFire 3800 with 8x750MHz + 8 GB RAM. Oracle 816.
> > >
> > > Thanks.
> >
> > Impossible for anyone to tell you as you have provided no information
> > from which an answer can be given. It depends on many factors including
> > whether the index is created using the NOLOGGING syntax.
> >
> > I would suggest, too, that there is no excuse for being on Oracle 8.1.6.
> > Not only is in unsupported it is buggy. At least get yourself to
> > 8.1.7.4.
> >
> > Daniel Morgan

I don't mean to be rude here but you can stand on one toe in bunny slippers and juggle flaming hoola-hoops. No one can possibly answer your question.

If you need to do it you need to do it. Just research all of the options for optimizing the process, run a benchmark on a test machine, and run it the way that is fastest.

Daniel Morgan Received on Sun Mar 30 2003 - 12:47:58 CST