Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Maintenance on Indexes
Create the appropriate 'drop index' and 'create index' statements automatically, by selecting the necessary details from the DBA_INDEXES and DBA_IND_COLUMNS (as you suggested) and spool the output to a file. You will probably need to create a temporary procedure to get the format just right but I wouldn't have thought it would take too long to write.
Perhaps you could post it once its been tested.
Gillian wrote in message <350E980F.6E456F8B_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 CST