ORA-03002 with query_rewrite_enabled=TRUE (Doc ID 1353034.1)

Last updated on AUGUST 29, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

With query_rewrite_enabled=TRUE,some queries may fail with the following error:
ORA-03002: operator not implemented

STACK:
ksedst <- ksedmp <- ksddoa <- ksdpcg <- ksdpec
<- ksfpec <- kgesev <- kgesec0 <- qcuErroer <- erroer
<- expgod <- xtyopncb <- qctcopn <- xtyopn <- kkqsevopt
<- kkqsvirg <- kkqsriDj <- kkqsEvaluateDisjointness <- kkqsComputeDisjointness <- kkqsMMVCkDisjunctDisjointness
<- kkqsMultiMVContDrv <- kkqsedrv <- kkqseqb <- kkqsrqb <- kkqsrmav
<- kkqsRewriteCurrentQB <- kkqscqb <- kkqsptq <- kkqsptqur <- kkqsrdrv
<- kkqdrv <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2
<- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor
<- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- main <- start

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