My Oracle Support Banner

CREATE TABLE ... AS SELECT (CTAS) Fails with ORA-3113 / ORA-7445[LdiDateToLDX()+37] (Doc ID 2571665.1)

Last updated on MARCH 04, 2020

Applies to:

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

Symptoms

When run as any user other than AS SYSDBA, CREATE TABLE ... AS SELECT (CTAS) fails with the following error in SQL*Plus:

ORA-03113: end-of-file on communication channel

The associated error in the alert log is:

ORA-07445: exception encountered: core dump [LdiDateToLDX()+37] [SIGSEGV] [ADDR:0xF] [PC:0x4E687E5] [Address not mapped to object] []

 

The associated incident trace file shows this Current SQL Statement:

BEGIN dbms_stats.postprocess_stats(:owner, :tabname, :partname, :subpartname, 6, :rawstats, :selmap, :clist); END;

along with this PL/SQL Call Stack:

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x14f766348 1621 package body SYS.DBMS_STATS
0x14f766348 28833 package body SYS.DBMS_STATS
0x14f6a63e8 1 anonymous block

and this Call Stack Trace:

LdiDateToLDX <- qosDateTimeToDate <- qospscs <- spefcmpa <- spefmccallstd <- pextproc
 <- peftrusted <- psdexsp <- kxe_push_env_internal_pp_
  <- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
   <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
    <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpuexec
     <- OCIStmtExecute <- qerandvPostProcessStatsInt <- qerandvPostProcessStats
     <- ctcdrv <- opiexe <- opiosq0 <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr

 

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


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