While testing, I made the index of a table unusable. It has total 7 index partitions.
But I am unable to make the index usable again. After searching on internet tried rebuilding each partitions. But the last partition (which has 95% data ) throws an error saying to increase table space of temp. Now I don't know if I made a big mistake.
Could anyone help me to make index usable again ?