PARTITION statement for regular tables, marks all partitions of a global index
UNUSABLE. You can rebuild the entire index by rebuilding each partition individually using the
PARTITION statement. You can perform these rebuilds concurrently.
You can also simply drop the index and re-create it.