Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to make index usable?

kalyan vedagiriJul 15 2021 — edited Jul 15 2021

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 ?

Comments
Post Details
Added on Jul 15 2021
2 comments
1,037 views