ORA-21780 from Insert As Select with SDO_GEOM.RELATE
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version: 10.2.0.4 to 220.127.116.11 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Add ***Checked for relevance on 09-Feb-2011***
- Insert as select fails with:
ERROR at line 111:
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "MDSYS.SDO_3GL", line 4
ORA-06512: at "MDSYS.MD2", line 769
ORA-06512: at "MDSYS.SDO_GEOM", line 2745
ORA-06512: at "MDSYS.SDO_GEOM", line 2785
- the select statement contains a SDO_GEOM.RELATE statement
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms