ORA-1467: SORT KEY TOO LONG AFTER UPGRADE TO 12.1
(Doc ID 1995276.1)
Last updated on FEBRUARY 20, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On : 12.1.0.1 version, RDBMS
"ORA-01467: sort key too long" after upgrade from 10g to 12c
After upgrade to 12.1.0.1 one of the fairly complex queries ends up in the error "ORA-01467: sort key too long".
The same query used to run without any problems in the 10g and 11g
----- Call Stack Trace -----
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAct
<- ions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE
<- 3368 <- dbkePostKGE_kgsf <- kgeade <- kgeselv <- kgesecl0
<- qcuErroer <- erroer <- qerwnAllocate <- qknRwsAllocateTree <- qknRwsAllocateTree
<- qknRwsAllocateTree <- qknDoRwsAllocate <- IPRA <- nDescendents <- IPRA
<- qkadrv2Post <- qkadrv2 <- opitca <- kksFullTypeCheck <- rpiswu2
<- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor
<- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main <- start
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 |
Cause |
Solution |
References |