来源: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的错误了