今天遇到此错,一头无数。百度到http://ms.itpub.net/redirect.php?fid=2&tid=1187496&goto=nextoldset
此牛人滴解答,备忘之
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.3 - 10.2
This problem can occur on any platform.
Errors
ORA 600 "internal error code, arguments: [qctcte1],[0],[%s], [%s], [%s],
Symptoms
ORA-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], [], [], [], [], [], []
Cause
An inconsistent datatype is reported during typechecking when parsing a query. This is bug 3557906.
Fix
There are several Workarounds :
1> Remove the desc from the order by clause
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 )
2> Alter session set "_complex_view_merging"=false;
3> Remove the distinct clause
Sql > 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 clause
Sql > 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 = false
This is fixed in 10.2 and will be fixed in the 9206 patchset.
References
<Bug:3557906> ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [QCTCTE1], [0],
解决办法:http://www.itpub.net/thread-213470-1-1.html本人环境 改成force之后还是不好使,各位试试吧
Oracle cursor_sharing 参数 详解 :http://blog.csdn.net/tianlesoftware/article/details/6551723
相关文章
- ORA-00600: 内部错误代码, 参数: [# of sumkeys invalid]
- ORA-00600: 内部错误代码,参数: [qctcte1], [0], [], [], [], [], [], []
- 有哪位试过在weblogig6。1下访问oracle9i?我这里会报如下错误:java.sql.SQLException: ORA-00600: 内部错误代码,参数: [ttcgcshnd-1],
- ORA-00600: 内部错误代码, 参数: [kcratr1_lastbwr]
- ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], []
- ORA-00600内部错误代码 求解
- 头疼的错误 ORA-00600 内部错误代码,参数:[kcbnew_3],[0],[43900],[]
- ORA-00600: 内部错误代码, 参数: [# of sumkeys invalid]
- ora-00600错误:内部错误代码
- ORA-00600_内部错误代码_参数19004