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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms