Solutions for 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]
We got this error in Oracle 10g. A little about our environment. This is 10.2.0.3 and we are using Transparent Data Encryption (TDE). I found on metalink that there is a bug (see note Note:406958.1) with Complex View Merging and Transparent Data Encryption (TDE).
The fix was to set _complex_view_merging=false or upgrade to 11g. The problem with this approach is that Oracle is not able to efficiently rewrite queries using Complex View Merging and the upgrade to 11g will introduce some risks. Queries that should take seconds may now take minutes due to disabling Complex View Merging. I found a better work around. Do not set _complex_view_merging=false. If you did, set it back to true. Find the offending view that is causing the problem and build it with the /*+ no_merge */ hint.
For example:
CREATE OR REPLACE FORCE VIEW V_TEST_VIEW
AS
SELECT DISTINCT fi.provider_id as fi_id
, co.provider_id as co_id
, ag.provider_id as ag_id
Instead, do this:
CREATE OR REPLACE FORCE VIEW V_TEST_VIEW
AS
SELECT /*+ no_merge */ DISTINCT fi.provider_id as fi_id
, co.provider_id as co_id
, ag.provider_id as ag_id
And there you go. You still get Complex View Merging except on views that contain columns that are encrypted by TDE.