Re: Maintenance on Indexes
Date: 1998/03/17
Message-ID: <6emvuu$fjj$1_at_nnrp1.dejanews.com>#1/1
Gillian,
There are a couple of ways you can do this (you can write a script to recreate
the index definitions), if you have Oracle 7.3 or above you can write a script
to do an alter index rebuild command. Or you can export the database
or the part you are interested in (rows=n) and import with parameter
indexfile=FILENAME. This will create a text file called FILENAME.sql - which
will have the create index commands. (the other create commands are also
listed but are commented out).
Let me know if you need more info -
Manish Asnani
masnani_at_corp2.pagemart.com
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 Tue Mar 17 1998 - 00:00:00 CET