My Oracle Support Banner

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

Last updated on JANUARY 17, 2020

Applies to:

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


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]




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

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