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 11.2.0.2 and laterInformation 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
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
| Symptoms |
| Cause |
| Solution |