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**********$$
$$**************Posted by Shishir Tekade**********$$
No comments:
Post a Comment