Maintenance on Indexes

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