我也遇到过此问题。估计可能是因数据有空格的问题造成的。 最好在关联查询的条件上加上trim函数来解决trim(字段1)＝trim(字段2) . 下面是解釋﹐你看看也許對你有幫助 ORA-00600 ORA-00600internal message code, arguments: [num], [?], [?], [?], [?], [?] Causehis is a catch-all internal message for ORACLE program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include: ·time-outs ·file corruption ·failed data checks in memory ·hardware, memory, or I/O messages ·incorrectly restored files The first argument is the internal message number; other arguments are various numbers, names, and character strings. (See section "Reporting a Problem to Worldwide Customer Support" on page 1-12 for more information.) The numbers may change meanings between different versions of the ORACLE Server. Action:Report this error to Worldwide Customer Support after gathering the following information: ·events that led up to the error ·the operations that were attempted that led to the error ·the conditions of the operating system and database at the time of the error ·any unusual circumstances that occurred prior to receiving the ORA-00600 message. ·contents of any trace files generated by the error ·the relevant portions of the Alert file NOTE: The cause of this error may manifest itself as different errors at different times. Be aware of the history of errors that occurred prior to this internal error.
最好在关联查询的条件上加上trim函数来解决trim(字段1)＝trim(字段2) .
下面是解釋﹐你看看也許對你有幫助
ORA-00600 ORA-00600internal message code, arguments: [num], [?], [?], [?], [?], [?] Causehis is a catch-all internal message for ORACLE program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include: ·time-outs ·file corruption ·failed data checks in memory ·hardware, memory, or I/O messages ·incorrectly restored files The first argument is the internal message number; other arguments are various numbers, names, and character strings. (See section "Reporting a Problem to Worldwide Customer Support" on page 1-12 for more information.) The numbers may change meanings between different versions of the ORACLE Server. Action:Report this error to Worldwide Customer Support after gathering the following information: ·events that led up to the error ·the operations that were attempted that led to the error ·the conditions of the operating system and database at the time of the error ·any unusual circumstances that occurred prior to receiving the ORA-00600 message. ·contents of any trace files generated by the error ·the relevant portions of the Alert file NOTE: The cause of this error may manifest itself as different errors at different times. Be aware of the history of errors that occurred prior to this internal error.