ORA-00600 [qertbFetchByRowID]

ORA-00600 [qertbFetchByRowID]错误一般与索引有关，该报错明确指出问题发生在通过ROWID信息读取表时，而通过ROWID读取是索引扫描的标志，一般来说这种问题是索引和表上数据的逻辑损坏造成的，如果问题出现在索引上，那么可以删除重建索引，或者使用ONLINE方式重建索引。报错相关SQL：
Current SQL statement for this session: SELECT "EXAM_APPOINTS"."EXAM_NO", "EXAM_APPOINTS"."NAME", "EXAM_APPOINTS"."SEX", "EXAM_APPOINTS"."EXAM_SUB_CLASS", "EXAM_APPOINTS"."EXAM_MODE", "EXAM_APPOINTS"."REQ_DATE_TIME", "EXAM_APPOINTS"."REQ_DEPT", "EXAM_APPOINTS"."REQ_PHYSICIAN", "EXAM_APPOINTS"."SCHEDULED_DATE", "EXAM_APPOINTS"."COSTS", "EXAM_MASTER"."RESULT_STATUS", "EXAM_REPORT"."IMPRESSION", "EXAM_REPORT"."MEMO", "EXAM_APPOINTS"."PATIENT_ID", "EXAM_APPOINTS"."NAME_PHONETIC", "EXAM_APPOINTS"."DATE_OF_BIRTH", "EXAM_APPOINTS"."BIRTH_PLACE", "EXAM_APPOINTS"."IDENTITY", "EXAM_APPOINTS"."CHARGE_TYPE", "EXAM_APPOINTS"."MAILING_ADDRESS", "EXAM_APPOINTS"."ZIP_CODE", "EXAM_APPOINTS"."PHONE_NUMBER", "EXAM_APPOINTS"."EXAM_CLASS", "EXAM_APPOINTS"."CLIN_SYMP", "EXAM_APPOINTS"."PHYS_SIGN", "EXAM_APPOINTS"."RELEVANT_LAB_TEST", "EXAM_APPOINTS"."RELEVANT_DIAG", "EXAM_APPOINTS"."CLIN_DIAG", "EXAM_APPOINTS"."EXAM_GROUP", "EXAM_APPOINTS"."PERFORMED_BY", "EXAM_APPOINTS"."PATIENT_SOURCE", "EXAM_APPOINTS"."FACILITY", "EXAM_APPOINTS"."REQ_MEMO", "EXAM_APPOINTS"."NOTICE", "EXAM_APPOINTS"."CHARGES", "EXAM_MASTER"."DEVICE", '0', "EXAM_APPOINTS"."VISIT_ID", "EXAM_APPOINTS"."LOCAL_ID_CLASS", "EXA 可以通过如下语句分析SQL语句中的所有表，来找出存在问题的索引。
analyze table TABLENAME validate structure cascade;但是此操作会在表上加上排它锁，所以此操作一定要谨慎。