当前位置: 代码迷 >> J# >> ora-08102:index key not found,obj#57848,file 六, block 6324(2)
  详细解决方案

ora-08102:index key not found,obj#57848,file 六, block 6324(2)

热度:6425   发布时间:2013-02-25 00:00:00.0
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的错误了
  相关解决方案