Rebuilding an index will require two copies of the index for a short period of time, the original copy and the new copy. The original copy is deleted as the last step in the index rebuild. You'll need enough room for both copies of the index until the rebuild is complete. This is the same in both 8i and 9i.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.