问题:
删除oracl数据库中某张表的某条记录时报错:
[color=red]index "SYS.IX_target" or partition of such index is in unusable state[/color]
解决方案:
--查询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;
删除oracl数据库中某张表的某条记录时报错:
[color=red]index "SYS.IX_target" or partition of such index is in unusable state[/color]
解决方案:
--查询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;