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: ,

Comments (5) -

9/16/2011 3:52:13 PM #

Jagjit Singh

Dear Sir/Madam

Thanks for your wonderful solution. I have also problem of complex view merging and it works fine with your solution.
alter session set "_complex_view_merging"=false;

Thanks
With Regards
Jagjit Singh

Jagjit Singh India

1/14/2012 2:28:44 PM #

Villas for Rent in Italy

I must appreciate your efforts regarding this!

Villas for Rent in Italy United States

2/18/2012 2:01:49 AM #

Ceramic Coating

Hi there, I think i came here by chance cause i was searching for new It development services i really liked the post cause it is very informative and interesting post. Keep up the awesome work. Thanks for sharing and letting me to share.

Ceramic Coating United States

6/3/2012 2:19:49 AM #

Directory Submission Service

Hi there, I think i came here by chance cause i was searching for new It development services i really liked the post cause it is very informative and interesting post. Keep up the awesome work. Thanks for sharing and letting me to share.

Directory Submission Service United States

6/10/2012 3:31:50 PM #

Iraqi Dinar

Thanks for your wonderful solution. I have also problem of complex view merging and it works fine with your solution.

Iraqi Dinar United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox