Question Locked
Decreasing the size of Oracle 9i indexes
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.