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

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

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'

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