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.
