ORA-01841 on a Query with or an an Interval Partitioned Table (Doc ID 2759862.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• Query errors with ORA-01841:
  ORA-01841: (full) year must be between -4713 and +9999, and not be 0

  ----- Call Stack Trace -----
  kdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
  <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAct <- ions
  <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE <- 1063
  <- dbkePostKGE_kgsf <- kgeselv <- ksesecl0 <- kkpamiGenHiBound <- 760
  <- kkpamRIDoMath <- kkpamRFGet <- kkpamFRange <- kkpapSetBounds <- kkpapnBuildNode
  <- kkpapnBuildSingleNo <- kkpapnBuildList <- kkpapDAFkkSLvl <- kkpapDAFkk <- kkqteGetRelevantPar
  <- titions <- kkqteCheckValidity <- kkqctCheckTransVali <- qksqbApplyToQbc <- kkqctdrvTD
  <- kkqtedrv <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca
  <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc
  <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpoal8 <- opiodr
  <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv

    
  
  
  

Changes

 Upgrade to 12.1.0.2

Cause

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