ORA-21780: Maximum Number Of Object Durations Exceeded. (Doc ID 2389380.1)

Last updated on JULY 05, 2024

Applies to:

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

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