Select Statement Failing with ORA-7445 [KKQTECHECKVALIDITY]
(Doc ID 2434247.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- 12.2.0.1 version, query errors with ORA-7445 [KKQTECHECKVALIDITY]:
ORA-07445: exception encountered: core dump [kkqteCheckValidity()+1875]dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=7yg5z1b0vpcvw) -----
select * from Test where owner!=user and rownum<1000Call Stack:
========
ksedsts <- kjzduptcctx <- kjzdpcrshnfy <- dbkedKstDump <- dbgdaExecuteAction
<- dbgerRunAction <- dbgerRunActions <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocationImpl
<- ssexhd <- sslsshandler <- __sighandler <- kkqteCheckValidity <- kkqctCheckTransValid
<- kkqctcvqb <- kkqctcvct <- kkqctChkCBQTvalid
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 |