Materialized Views Refresh fails With ORA-01403: No Data Found After Upgrade To 19C (Doc ID 2895541.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Symptoms

BEGIN DBMS_MVIEW.refresh('<<<>>>>>'); END;
Error at line 1
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 347
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2893
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3295
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16
ORA-06512: at line 1

From the trace file:

PARSING IN CURSOR #140466823891584 len=79 dep=1 uid=0 oct=3 lid=0 tim=2535446085176 hv=276141043 ad='4bf716d38' sqlid='7n63dq887b4zm'

SELECT COLLECTION_LEVEL FROM SYS.MVREF$_STATS_SYS_DEFAULTS FETCH FIRST ROW ONLY ◄◄◄◄◄◄

END OF STMT

STAT #140466823891584 id=3 cnt=0 pid=2 pos=1 obj=7110197 op='TABLE ACCESS FULL MVREF$_STATS_SYS_DEFAULTS (cr=3 pr=0 pw=0 str=1 time=34 us cost=2 size=13 card=1)'

STACK TARCE

dbkedDefDump <- ORA-01403 <- BEGIN <- 0x31fca0b28 <- 0x31fca0b28
       <- 0x31fca0b28 <- 0x31fca0b28 <- 0x43facd028 <- 0x25d1897a0 <- ksedst1
        <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction
         <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAct <- ions <- dbgdChkEventKgErr
          <- dbkdChkEventRdbmsEr <- dbgePostErrorKGE <- 1066 <- dbkePostKGE_kgsf <- kgeade
           <- kgeselv <- ksesecl0 <- psddr0 <- psdnal <- pevm_EXECC
            <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt
             <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip
              <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
               <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start

Changes

 Upgrade to 19C.

Cause

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