ORA-00600的错误

farrio 2004-10-11 03:07:35
同样的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;

而且,如果我把**行去掉,就正常了。太奇怪了。
...全文
98 4 打赏 收藏 举报
写回复
4 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
bzszp 2004-10-11
  • 打赏
  • 举报
回复
出现这个错误一般是自己解决不了的
LGQDUCKY 2004-10-11
  • 打赏
  • 举报
回复
ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

这个是ORACLE内部出错,你要看[string], [string],里面的参数,一般的DBA是很难处理的
一般只有找ORACLE的人,不过看来只是你的语句引起的,要注意备份数据库
wylwyl1130 2004-10-11
  • 打赏
  • 举报
回复
ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

timeouts
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.

bzszp 2004-10-11
  • 打赏
  • 举报
回复
这个错误号是不是提示内部错误啊
发帖
Oracle 高级技术

3472

社区成员

Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
帖子事件
创建了帖子
2004-10-11 03:07
社区公告
暂无公告