同样的SQL语句,如果我的数据是十几条的时候,就能够正常工作。
如果我的数据增加到一万多条,就出这样的错误。怎么回事?
我的SQL是
SELECT LPD002_F21.DJDM, LPD002_F21.SJGSCIFID
FROM LPD002_F21 LPD002_F21, LPD024 LPD024
WHERE
LPD002_F21.JZNY = '200409' AND
LPD002_F21.JZNY = LPD024.JZNY AND --***
LPD002_F21.WDDM = LPD024.WDDM AND
LPD002_F21.CIFID = LPD024.CIFID
ORDER BY LPD002_F21.SJGSCIFID ASC, LPD002_F21.SXQFBZ DESC;而且,如果我把**行去掉,就正常了。太奇怪了。
如果我的数据增加到一万多条,就出这样的错误。怎么回事?
我的SQL是
SELECT LPD002_F21.DJDM, LPD002_F21.SJGSCIFID
FROM LPD002_F21 LPD002_F21, LPD024 LPD024
WHERE
LPD002_F21.JZNY = '200409' AND
LPD002_F21.JZNY = LPD024.JZNY AND --***
LPD002_F21.WDDM = LPD024.WDDM AND
LPD002_F21.CIFID = LPD024.CIFID
ORDER BY LPD002_F21.SJGSCIFID ASC, LPD002_F21.SXQFBZ DESC;而且,如果我把**行去掉,就正常了。太奇怪了。
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files
The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.Action: Report this error to Oracle Support Services 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 databases at the time of the error
any unusual circumstances that occurred before receiving the ORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alter files
Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
一般只有找ORACLE的人,不过看来只是你的语句引起的,要注意备份数据库