Decreasing the size of Oracle 9i indexes - TechRepublic
Question
January 20, 2009 at 09:50 PM
robert

Decreasing the size of Oracle 9i indexes

by robert . Updated 17 years, 5 months ago

I have an aging db that I am supporting that has a massive INDEXES.dbf file. I suspect this is bloated due to loading and deleting of successive data tables.

Is there an easy was to clear out the indexes and rebuild them?

P.S. My Oracle knowledge is sadly at the beginner level.

This discussion is locked

All Comments