My Oracle Support Banner

Unable To Add Spatial Metadata For GEO_PT_INFO Table (Doc ID 1485659.1)

Last updated on JUNE 25, 2021

Applies to:

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


Trying to add spatial metadata for GEO_PT_INFO table fails with:

insert into user_sdo_geom_metadata values('GEO_PT_INFO', 'GEO_PT ',
13:36:52 2 sdo_dim_array(sdo_dim_element('X', -180.0, 180.0, 0.5),
13:36:52 3 sdo_dim_element('Y', -90.0, 90.0, 0.5)), 8307);
insert into user_sdo_geom_metadata values('GEO_PT_INFO', 'GEO_PT ',
ERROR at line 1:
ORA-13223: duplicate entry for GEO_PT_INFO.GEO_PT in SDO_GEOM_METADATA
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 21
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'


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

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