Oracle SQL index rebuild

 

错误：

ORA-01502: index <index_name> or partition of such index is in unusable state.

 

如果是index unusable

ALTER INDEX <index_name> REBUILD;

 

如果是partition下index unusable

ALTER INDEX <index_name> REBUILD PARTITION <partition_name>;