My Oracle Support Banner

ORA-00600: [24000] When Creating OUTLINE with HINTSQL (Doc ID 1494943.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

When Creating an outline with HINTSQL fails with the error ORA-00600:

CREATE  OUTLINE HINTSQL ON
SELECT/*+FIRST_ROWS DOMAIN_INDEX_NO_SORT*/

ORA-00600: internal error code, arguments: [24000], [qolhins: unexpected constraint violation], [], [], [], [], [], []


The SQL statement does not have any CONNECT BY clauses.

Call stack trace is similar to:

 ksesic1 <- qolhins <- qolupd <- qolchg <- kglfls1
       <- ktcCommitTxn <- solcre <- opitca <- kksLoadChild <- kxsGetRuntimeLock

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.