ora-20085 ora-06512错误解决

Oracle中使用sde_geometry 更新空间数据中遇到的错误

ORA-20085: Insert Spatial Reference SRID 4490 does not match SDE.**.SHAPE registered Spatial Reference SRID 300005
ORA-06512: 在 "SDE.ST_DOMAIN_METHODS", line 2000

解决方法：

1. Connect to the Oracle instance/geodatabase using SQL*Plus as the sde user.

2. Identify the name of the gdb_items spatial index:
 

SQL> SELECT index_name FROM user_ind_columns WHERE table_name = 'GDB_ITEMS' and column_name = 'SHAPE';

INDEX_NAME
------------------------------
A29_IX1

 

3. Drop the spatial index:
 

SQL> DROP INDEX A29_IX1;

Index dropped.

如果还是有问题，把对应srid更新 

update sde.ST_GEOMETRY_INDEX x set  x.srid=4490  where srid=300005;
 update sde.ST_GEOMETRY_COLUMNS t  set  t.srid=4490 where t.srid=300005

具体详见arcgis技术支持https://support.esri.com/en/technical-article/000012015