最近业务短信经常报出如下异常:
系统错误编码:ORA-01410:无效的ROWID,错误源:PKG_BASE_DATA_XXXX,本地错误信息:TABLE_NAME=T_XXXX_CONN_MAC,错误位置:1-6.
结合业务场景,经分析,是索引失效导致的big query无法检索到正确的数据。表数据是通过sqlldr使用direct方式加载到表中。下面主要分析一下这个异常。
Oracle Error: ORA-01410
Error Description:Invalid ROWID
Error Cause:
A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F.
A typical ROWID format is '000001F8.0001.0006'.
A relatively frequent cause of the error comes from the habit of using automatic programs to rebuild multiple indexes.
For example, if you rebuild an index, Oracle will copy the index contents from one location to another and when the copy is complete, it will f