Post Stops due to Error: "ORA-08102: index key not found"
说明
The post process stops due to error and the event log indicates the following error:
"Notice: ORA-08102: index key not found, obj# 6710, dba 683920159 (2). [sp_opst_mt(osp)/13300] Error: Unexpected Oracle error: ORA-08102: index key not found, obj# 6710, dba 683920159 (2). (object name: "XXXXXXXXXX")"
原因
This is an Oracle error and it occurs when there is a mismatch between the key(s) stored in the index and the values stored in the table.
解决办法
1. Stop post.
2. Rebuild the index on the table the error occurs on.If this does not work you may have to drop and re-create the index.
3. Start post.
For more details about the Oracle error please see this metalink doc : https://metalink.oracle.com/metalink/plsql/f?p=130:3:4177507929753620108::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame,p3_font:NOT,1034886.6,1,1,1,helvetica