ORA-00600 [qertbFetchByRowID]

Bethune 2016-08-21
13
0 0
摘要: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;但是此操作会在表上加上排它锁,所以此操作一定要谨慎。
「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部