[Err] ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []
来源:互联网 发布:网络用语ysl什么意思 编辑:程序博客网 时间:2024/06/08 17:56
今天写程序,后台不报错,页面数据死活显示不出来,把sql语句直接放到数据库运行了一下,报错:[Err] ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []
百度结果:
The information in this article applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.3 - 10.2This problem can occur on any platform.ErrorsORA 600 "internal error code, arguments: [qctcte1],[0],[%s], [%s], [%s],SymptomsORA-00600 [qctcte1] is encountered while performing a nested select which might include functions like distinct or have an order by clause.Example:Sql> CREATE OR REPLACE TYPE int_list IS VARRAY(200) OF INTEGER;Sql> CREATE TABLE test (id INTEGER);Sql> SELECT id FROM ( SELECT rp.id FROM (SELECT DISTINCT column_value ID FROM TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id DESC)ERROR at line 2:ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []CauseAn inconsistent datatype is reported during typechecking when parsing a query. This is bug 3557906. FixThere are several Workarounds :1> Remove the desc from the order by clauseSql > SELECT id FROM ( SELECT rp.id FROM (SELECT DISTINCT column_value ID FROM TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id )2> Alter session set "_complex_view_merging"=false;3> Remove the distinct clauseSql > SELECT id FROM ( SELECT rp.id FROM (SELECT column_value ID FROM TABLE(int_list (1,1,2))) rp, test p WHERE p.id = 1 ORDER BY p.id DESC)4> Remove the order by clauseSql > SELECT id FROM ( SELECT rp.id FROM(SELECT column_value ID FROM TABLE(int_list(1,1,2))) rp, test p WHERE p.id = 1 ) 5> _pred_move_around = falseThis is fixed in 10.2 and will be fixed in the 9206 patchset. References<Bug:3557906> ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [QCTCTE1], [0],
去掉 order by后面的可以了
[SQL]select count(*) from( SELECT -1 METADATA_HISTORY_ID, METADATA_ID, '当前(未发布)' VERSION_NUMBER, RELEASE_DATE, RELEASE_USER, B.CLASS_ID, CLASS_CODE, B.CLASS_NAME, METADATA_CODE, METADATA_NAME FROM MM_METADATA A, MM_CLASS B WHERE A.CLASS_ID = B.CLASS_ID AND A.METADATA_ID = 13 AND A.METADATA_STATUS = 'E' UNION ALL SELECT METADATA_HISTORY_ID, METADATA_ID, VERSION_NUMBER, RELEASE_DATE, RELEASE_USER, B.CLASS_ID, CLASS_CODE, B.CLASS_NAME, METADATA_CODE, METADATA_NAME FROM MM_METADATA_HISTORY A, MM_CLASS B WHERE A.CLASS_ID = B.CLASS_ID AND METADATA_ID = 13 )
1 0
- [Err] ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数: [qctcte1], [0], [], [], [], [], [], []
- ora-00600 内部错误代码 参数:.........
- ORA-00600: 内部错误代码, 参数: [17114], [0x2A97775EF8], [], [], [], [], [], []
- ERROR: ORA-00600: 内部错误代码, 参数: [17182], [0x2AE72343B77C], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [qkacon:NFswrwo]
- ORA-00600: 内部错误代码, 参数: [evapls1], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数[qerpfAllocateR], [], [], [], [], [],
- ora-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码,参数: [kcratr1_lostwrt], [], [], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], []
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [kkdoilsn1]
- ORA-00600 内部错误代码, 参数 [kdsgrp1]
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [kqlnrc_1]
- Android layout_weight理解
- 游戏服务器主程白皮书-序言
- HDU 3038 How Many Answers Are Wrong(带权并查集)
- JAVA和.NET使用DES对称加密的区别
- POJ 3468 A Simple Problem with Integers(区间更新+区间求和)
- [Err] ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], [], [], [], [], []
- 使用 cURL 进行 HTTP 请求实例
- 纸上谈兵: 最短路径与贪婪
- Algorithms—264.Ugly Number II
- 正反斜杠的匹配
- jquery无法设置checkbox选中即没有变成选中状态
- java web解决表单重复提交问题
- hdu3496(二维背包问题)
- 在android5.1的init进程中加入读取手机序列码