ORA-01841 on a Query with or an an Interval Partitioned Table
(Doc ID 2759862.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Information in this document applies to any platform.
ORA-01841 ON A QUERY WITH OR ON AN INTERVAL PARTITIONED TABLE
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
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 |