ORA-1445 or ORA-1446 Referencing ROWID from a View with Subquery (Doc ID 1364607.1)

Last updated on OCTOBER 08, 2014

Applies to:

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

Symptoms

Mview refresh fails with
ORA-12012: error on auto execute of job 122
ORA-12008: error in materialized view refresh path
ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY,

Call Stack will look like:

ksedmp <- ksddoa <- ksdpcg <- ksdpec <- PGOSF33_ksfpec <- kgesev
<- kgesec0 <- qcuErroer <- qcuErroep <- erroep <- vopgrid <- voptco
<- voptop <- voptot <- voptop <- voptot <- voptop <- voptot <-
voptop <- voptot <- voptop <- voptot <- voptop <- voptot <- voptop
<- voptref <- vopqbc <- vopqbc <- vopdrv <- kkqdrv <-
opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild
<- kxsGetRuntimeLock <- 016 <- kksfbc <- kkspsc0 <- kksParseCursor
<- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <-
opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- opimai <- OracleThreadStart <- 0000000077D6B71A

Changes

After database upgrade from 10.2.0.4 to 10.2.0.5.
However, this could happen on version 10.2 ,  11.1 and 11.2.
The issue is fixed in 12.1 (future release).

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