ORA-07445 [mdrcrrdtbl] WHEN CREATING A SPATIAL INDEX (Doc ID 1069157.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

While creating spatial index following error is returned.

ORA-07445: exception encountered: core dump [mdrcrrdtbl()+1600] [SIGSEGV] [Invalid permissions for mapped object] [0xFFFFFFFF79AB0000] [] []


Current SQL

-----------------

Failing sql statement would be like :

CREATE INDEX  <> ON <> (<>)  INDEXTYPE IS MDSYS.SPATIAL_INDEX ;



Call Stack

--------------

 mdrcrrdtbl <- mdrcrclmem <- mdrcrcluster <- mdrcrcnstree <- mdrtcrt
<- mdidxrbd <- mdidxcr <- spefcpfa <- spefmccallstd <- peftrusted
<- psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal
<- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peidxr_run <- peidxexe <- kkxdexe <- kkxmpexe <- kgmexwi
<- kgmexec <- evapls <- evaopn2 <- qximeop <- qerexStart
<- kdicrws <- kdicdrv <- opiexe <- opiosq0 <- kpooprx
<- kpoal8

Changes

Data in spatial table is high and resources like SGA size is not big enough to create spatial index. 

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