ORA-07445: exception encountered: core dump [qctstc2o()+199] (Doc ID 1571398.1)

Last updated on JANUARY 17, 2020

Applies to:

Symptoms

PL/SQL block with hint MATERIALIZE and using SDO_INTERSECTION gets error: ORA-07445: exception encountered: core dump [qctstc2o()+199]

With soils as
  (
  select /*+ ordered index (....) no_parallel materialize */ mukey,
  sdo_geom.sdo_intersection(shape, plot_geometry_sdo, 0.05) inter
  from plot_geometry_sdo psdo, .... b
  where sdo_anyinteract (shape, plot_geometry_sdo) = 'TRUE'
  and plot_id = 803572474839041
  )
  SELECT /*+ ordered index(....) */ a.tile
  FROM ...., .... a
  WHERE a.tile_id = 0
  AND a.analysis_version_id = 9388170904
  AND a.plot_id = 803572474839041
  AND sdo_inside (a.tile,inter) = 'TRUE'

  *
ERROR at line 5:
ORA-03113: end-of-file on communication channel
Process ID: 7398
Session ID: 162 Serial number: 13

I get error:

  ORA-07445: exception encountered: core dump [qctstc2o()+199]

Changes

Cause

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