When do indexes become unusable in Oracle?
If the physical location of the table's data changes during an operation, then Oracle marks the indexes on the table as unusable. The current rowids of the table's data, after the move, point to new location. The old rowids in the index, from before the move command, still point to the old location where there is no data.
DA: 57 PA: 55 MOZ Rank: 30