Re: Maintenance on Indexes

I should have said I am running Oracle 7.1.4. I wish I had the BUILD option. We are moving to 7.3 in the next few weeks though.

Alan V wrote:

> Why not use the rebuild option in 7.3 ? Build larger extents, too.
>
> Alan
>
> Gillian wrote in message <350E982F.C1FE92BB_at_entergy.com>...
> >I need to cut down the fragmentation on the indexes in Financials.
> >
> >Is there a statement I can use to DROP and CREATE all simultaneously.
> >There are about
> >12526 indexes. I could probably use the DBA_IND_COLUMNS table together
> >with the
> >DBA_INDEXES table.
> >
> >Let me know.
> >Much appreciated.
> >
> >Gillian
> >zmkj04_at_hotmail.com
> >
Received on Tue Mar 17 1998 - 00:00:00 CET