Re: Maintenance on Indexes
From: <edawad_at_yahoo.com>
Date: 1998/03/18
Message-ID: <6ep7fo$e7n$1_at_nnrp1.dejanews.com>#1/1
Eddie
Date: 1998/03/18
Message-ID: <6ep7fo$e7n$1_at_nnrp1.dejanews.com>#1/1
In Oracle version 7.3 and Oracle8 the ALTER INDEX ... REBUILD command can be used to rebuild indexes on the fly.
Eddie
In article <350E982F.C1FE92BB_at_entergy.com>,
Gillian <gmuruga_at_entergy.com> wrote:
>
> 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
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 18 1998 - 00:00:00 CET