Monday 10 December 2012

ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [1], [0]


ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [1], [0]

Call Stack Trace section in the trace file generated by the error contains the following functions:

qctValidCharOpn qctsto2o  ...


Cause
This is Bug 5603197 ORA-600 [QCTVCO:CSFORM]  from UPDATE SQL with a subquery
Details: Update statement with subquery failed with ORA-600 [qctVCO:csform]


  
Solution

To implement the solution, we have the following options:

1. Use the workaround:

Set  _complex_view_merging to false.

Database level:
SQL> alter system set "_complex_view_merging"=false scope=both;

Session level

SQL> alter session set "_complex_view_merging"=false;


2. Bug 5603197 is fixed in 10.2.0.4 and 11.1.0.6. upgrade to these patchsets or higher where the bug is fixed.

3. Check on MOS to see if Patch 5603197 is available on your database version and platform.

                       $$**************Posted by Shishir Tekade**********$$

No comments:

Post a Comment