OCP Blog
Super DBA
ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
by Vazha Mantua Thursday, August 18, 2011 5:26 PM
In a test DB we applied patch from 10.2.0.2 to 10.2.0.4 , after this procedure we could ’t compile a user specified view with error :ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
On metalink there are a lot of articles and scenarios with this error, but I will focus on only one,which help us.
Problem
--------
SQL statement with aggregations and unions fail with
ORA-600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], [] during parse.


--------------------
Solution:
disable query_rewrite make it works fine.
alter session set "_complex_view_merging"=false;
Init parameter “_complex_view_merging”- Controls complex view merging.

Tags: ,

Filter by APML

Calendar

<<  June 2018  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

TextBox