ORA-21780: Maximum Number Of Object Durations Exceeded.

(Doc ID 2389380.1)

Last updated on APRIL 20, 2018

Applies to:

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

Symptoms

--where sub table has > 10000 rows with geometries

create table maintable1 as
select distinct a.sua_name sua_name, b.sua_name conflict_name,
SDO_GEOM.RELATE(a.SHAPE, 'DETERMINE', b.SHAPE, 800.0) rel
FROM sub_table a, sub_table b
where a.sua_name <> b.sua_name
and SDO_FILTER(a.shape, b.shape, 'querytype=JOIN') = 'TRUE';
SDO_GEOM.RELATE(a.SHAPE, 'DETERMINE', b.SHAPE, 800.0) rel
*
ERROR at line 3:
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "MDSYS.SDO_3GL", line 4
ORA-06512: at "MDSYS.SDO_3GL", line 28
ORA-06512: at "MDSYS.MD2", line 655
ORA-06512: at "MDSYS.SDO_GEOM", line 858
ORA-06512: at "MDSYS.SDO_GEOM", line 899

 

 

Changes

 

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