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 11.2.0.3 and laterInformation 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 (....) 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
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 |
Changes |
Cause |
Solution |