Nothing but my learning and experience with Oracle..!

LOcal  partitioned  Index In a local partitioned index, the number of index partitions will match the number of partitions in the base t...

In very rare case, We may end up in situation like some logical mistake has been happened to our production database and as a last resort ...