The ALTER
TABLE
MOVE
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 ALTER
INDEX
REBUILD
PARTITION
statement. You can perform these rebuilds concurrently.
You can also simply drop the index and re-create it.