Materialized View Refresh fails with ORA-2097 (Doc ID 2091089.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

After setting the "_FIX_CONTROL" parameter,Materialized View refresh in Non-Atomic Mode fails with ORA-2097

The error stack trace for ORA-2097,shows failing statment and stack similar to:

----- Current SQL Statement for this session
ALTER SESSION SET "_fix_control" = "nnnnnnn:OFF, mmmmmmm:OFF"

object line object
handle number name
c000000798a3be60 1872 package body SYS.DBMS_I_INDEX_UTL
c000000798e2f100 476 package body SYS.DBMS_SNAPSHOT
c0000007978929d0 1 anonymous block

STACK TRACE:
------------
skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
<- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <-
dbgdProcessEventAct <- ions
<- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <-
dbgePostErrorKGE <- 2144
<- dbkePostKGE_kgsf <- 128 <- kgeade <- kgeselv <- ksesecl0
<- $cold_kspsetv0 <- $cold_kkyase <- kksExecuteCommand <- opiexe <-
opipls
<- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2
<- rpidrv <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM
<- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe
<- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc
<- kpurcsc <- kpuexec <- OCIStmtExecute <- jslvec_execcb <-
jslvswu
<- jslve_execute0 <- jslve_execute <- rpiswu2 <- kkjex1e <-
kkjsexe
<- kkjrdp <- opirip <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- main_opd_entry

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.