0

ORA-00600 [qertbFetchByRowID]

Bethune 2016-08-21
181
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;但是此操作会在表上加上排它锁,所以此操作一定要谨慎。
「喜欢文章,快来给作者赞赏墨值吧」
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论