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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

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 (b NA_US_SOIL_MUPOLYGON_SIDX) no_parallel materialize */ mukey,
  sdo_geom.sdo_intersection(shape, plot_geometry_sdo, 0.05) inter
  from plot_geometry_sdo psdo, NA_US_SOIL_MUPOLYGON b
  where sdo_anyinteract (shape, plot_geometry_sdo) = 'TRUE'
  and plot_id = 803572474839041
  )
  SELECT /*+ ordered index(a plot_grid_stg_sidx ) */ a.tile
  FROM soils, plot_grid_stg 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]

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