MERGE Statement on Table with Constraints = ORA-7445[kxccexi()+153]

(Doc ID 2402003.1)

Last updated on JUNE 15, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The following error occurred in the alert log:

ORA-07445: exception encountered: core dump [kxccexi()+153] [SIGSEGV] [ADDR:0x8] [PC:0x2CC0859] [Address not mapped to object] []

 

The Call Stack Trace in the associated incident trace file shows:

<- kxccexi <- kxccresIndex <- kxccres <- updref <- updConstraintsAndART <- updrow <- qerusRop <- qervwRowProcedure <- qerhjWalkHashBucket <- qerhjGenProbeHashTable <- kdstfRRRRRRRRRRRRRRkmP <- kdsttgr <- qertbFetch <- qergiFetch <- qergiFetch <- rwsfcd <- qerhjFetch <- qervwFetch <- rwsfcd <- qerusFetch <- updaul <- updThreePhaseExe <- upsexe <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- rpidrv <- 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

and the Current SQL Statement is:  MERGE INTO ...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms