读书人

ora-08102:index key not found,obj#5

发布时间: 2012-11-06 14:07:00 作者: rapoo

ora-08102:index key not found,obj#57848,file 6, block 6324(2)
来源:http://blog.csdn.net/wyzxg/article/details/4761341

索引坏了,查出这个表的索引

select * from user_indexes t where t.table_name= upper('tb_ware')

组装成下面的语句执行:
alter index PK_TB_WARE rebuild online;
alter index AK_TB_WARE rebuild online;
alter index IDX_TB_WARE_PRINTSTATE rebuild online;
alter index IDX_WARE_END_TIME rebuild online;
alter index IDX_WARE_LOTTERY_ID rebuild online;
alter index IDX_WARE_LOTTERY_STATE rebuild online;
alter index IDX_WARE_TEAM_NAME rebuild online;


再次使用这个表,或到alert.log里就没有ora-08102的错误了

读书人网 >.NET

热点推荐