ORA-07445: exception encountered: core dump [qmxtraAddOpt()+3597] during impdp (Doc ID 1934520.1)

Last updated on OCTOBER 10, 2014

Applies to:

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

Symptoms

ORA-07445: exception encountered: core dump [qmxtraAddOpt()+3597] generated during IMPDP.  Incident trace file shows the error occured while creating a view during impdp:

*** MODULE NAME:(Data Pump Worker) 2014-10-01 12:27:21.161
*** ACTION NAME:(SYS_IMPORT_FULL_01) 2014-10-01 12:27:21.161
Dump continued from file: /apps/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_dw00_24242.trc
ORA-07445: exception encountered: core dump [qmxtraAddOpt()+3597] [SIGSEGV] [ADDR:0x0] [PC:0xD1272F] [Address not mapped to object] []

----- Current SQL Statement for this session (sql_id=d0t213wy2zct3) -----
CREATE FORCE VIEW "USER1"."V_USER1_IOCS_INITIATE"
("AGR_SERIAL", "IOCS_URL", "IOCS_TRANSACTION_ID")
AS WITH InitiateTransaction
  AS (SELECT dri.agr_serial AGR_SERIAL, cxd.cxd_xmldata cxd_xmldata
  FROM cr_xml_data cxd, references REF, AGREEMENTS dri
...


Call stack is

sighandler <- qmxtraAddOpt <- qmxtraAnalyzeOpt <- qmxtraAnalyzeOpt
<- qmxtraAnalyzeOpt <- qmxtraAnalyzeOpn <- qmxtraAnalyzeOptChd
<- qmxtraAnalyzeOpt <- qmxtraAnalyzeOpn <- qmxtraAnalyzeOptChd

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