"这个问题难倒我了,大家帮帮忙好吗(急)" 下集--出问题了

[复制链接]
查看11 | 回复4 | 2014-2-19 11:55:14 | 显示全部楼层 |阅读模式
具体情况是这样的:
http://www.itpub.net/523671.html
在系统运行的时候有些语句是没问题了,但执行了下面这条语句就报错了
insert into BB26(BBB367,BAB001,AAE001,BBB466,BBB467,BBB468,
BBB469,BBB470,BBB471,BBB472,BBB473,BBB474,BBB475,BBB476,
BBB477,BBB478,BBB479,BBB480,BBB481,BBB482,BBB483,BBB484,
BBB485,ACB572,AAC131,BBB486,BBB487,BBB488,BBB489,BBB490,
BBB491,BBB492,BBB493,AAE013,BAE001,BAE002,BAE006)
select c.BBB367 BBB367,c.BAB001 BAB001,c.AAE001 AAE001,
a.YDLX BBB466,a.SFKNQY BBB467,a.NSRBH BBB468,a.SSGXK BBB469,
a.SSHFK BBB470,a.YLXRS0 BBB471,a.YLXJE0 BBB472,a.YLXQF0 BBB473,
a.GSXRS0 BBB474,a.GSXJE0 BBB475,a.GSXQF0 BBB476,a.SYXRS0 BBB477,
a.SYXJE0 BBB478,a.SYXQF0 BBB479,a.SYXRS1 BBB480,a.SYXJE1 BBB481,
a.SYXQF1 BBB482,a.YLXRS1 BBB483,a.YLXJE1 BBB484,a.YLXQF1 BBB485,
a.ZRS ACB572,a.ZNJ AAC131,a.QFZE BBB486,a.YLBXRQ0 BBB487,
a.GSBXRQ0 BBB488,a.SYBXRQ0 BBB489,a.SYBXRQ1 BBB490,
a.YLBXRQ1 BBB491,a.JBLXR BBB492,a.JBRLXDH BBB493,
a.BZ AAE013,c.BAE001 BAE001,c.BAE002 BAE002,c.BAE006 BAE006
from NSSBSJ a left join ab01 b on a.dwsbbm=b.BAB001
left join bb23 c on c.BAB001=b.BAB001 where c.BBB367=80
java.sql.SQLException: ORA-00600: internal error code, arguments: [16608], [4],
[0], [0x000000000], [], [], [], []
at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava.lang.String;
Ljava.lang.String;I)V(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(Z)V(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError()V(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive()V(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(ZZZZ)V(T4CPreparedSta
tement.java:181)
请问是什么原因?查了很久了~~~~
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
上metalink查查吧
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
TIP:Click help for a detailed explanation of this page.
Bookmark Go to End
Subject:ORA-600 [16608]
Doc ID:Note:138527.1 Type:REFERENCE
Last Revision Date:06-MAR-2006 Status:PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.
SUGGESTIONS:
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
Known Issues:
Bug# 4401000 See Note 4401000.8
OERI[16608] during import of transportable tablespace
Fixed: 9.2.0.8, 10.1.0.5, 10.2.0.2, 11

Bug# 4095802 See Note 4095802.8
Concurrent DROP / LOCK against same table can fail with OERI[16608]
Fixed: 9.2.0.8, 11

Bug# 2716265 See Note 2716265.8
OERI[16608] can occur on SELECT using STAR transformation with RLS
Fixed: 9.2.0.4, 10.1.0.2

Bug# 2276981 See Note 2276981.8
OERI:16608 possible if a session DROPS a dependent object of a query
Fixed: 9.0.1.4, 9.2.0.2, 10.1.0.2

Bug# 1409835 See Note 1409835.8
OERI:16609 / OERI:16608 possible on operations which involve constraints
Fixed: 8.1.7.2, 9.0.1.1, 9.2.0.1
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
不通过数据链路的时候系统运行正常的。是不是跟数据链路有关呢
回复

使用道具 举报

千问 | 2014-2-19 11:55:14 | 显示全部楼层
最初由 hyq2000v 发布
[B]不通过数据链路的时候系统运行正常的。是不是跟数据链路有关呢 [/B]

恩,或许是个BUG
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行