问题: 删除oracl数据库中某张表的某条记录时报错: index "SYS.IX_target" or partition of such index is in unusable state 解决方案: --查询UNUSABLE状态的index select index_name, status, owner from dba_indexes where STATUS = 'UNUSABLE'; --组装重新编译index的sql语句 select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where STATUS = 'UNUSABLE'; --执行组装好的语句 alter index SYS.IX_target rebuild;
转载于:https://my.oschina.net/u/2381604/blog/751538