With clause sub-query having views failing with ORA-979 on 12.1.0.2
(Doc ID 2580678.1)
Last updated on AUGUST 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.1 BETA [Release 12.1 to 18]Information in this document applies to any platform.
Symptoms
With clause sub-query having views failing with ORA-979
Query syntax may look like below..
WITH tab AS (
SELECT col1
FROM (
SELECT MAX(col1) col1
FROM schema1.tab1
WHERE col2 = 'XYZ'
)
)
,tab2 AS (
SELECT ..
)
,tab3 AS (
SELECT ..
)
,tab4 AS (
SELECT ..
)
,tab4 AS (
SELECT ..
FROM schema1.tab1 gl
INNER JOIN ..
...
GROUP BY gl.col1
..
,CONCAT (
'O_'
,CONCAT (
REGEXP_REPLACE(...)
,gl.xyz
..
,gl_fte AS (
SELECT ..
)
SELECT ..
UNION ALL
SELECT ..
GROUP BY ..
UNION ALL
SELECT ..
GROUP BY ..;
Changes
Call Stack kkqctdrvTD <- kkqdrv <- kkqctdrvIT >> Matching with bug 29990369
skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <-
dbgdProcessEventAct <- ions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <-
ksfpec <- qecgoc <- qecsel <- qecpqbcheck <- qecpqbcheckNSE <- kkqtutlCheckGroupBy <- kkqvmValidCVM <- kkqvmTrMrg
<- kkqvmTrMrg <- kkqvmTrMrg <- kkqvmTrMrg <- kkqvmdrv2 <- kkqctdrvTD
<- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksLoadChild
<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
<- main <- libc_start_main <- start
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 |
Changes |
Cause |
Solution |
References |