gis报错ORA-29861

查看索引状态：

select index_name, table_name, index_type, domidx_status, domidx_opstatus,status from user_indexes where index_type=‘DOMAIN’ order by 1;

发现有3个索引status=‘INPROGRS’
获得索引创建DDL：

select dbms_metadata.get_ddl(‘INDEX’,‘A181_IX1’,‘SDE’)||chr(10)||’/’ from dual;

删除status='INPROGRS’的索引：

drop index A70_IX1 force;

重建索引：

CREATE INDEX “SDE”.“A70_IX1” ON “SDE”.“OFFTAKE” (“SHAPE”)
INDEXTYPE IS “SDE”.“ST_SPATIAL_INDEX” PARAMETERS (‘ST_GRIDS = 0 ST_SRID = 300004 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4’)
/
CREATE INDEX “SDE”.“A180_IX1” ON “SDE”.“放散塔” (“形状”)
INDEXTYPE IS “SDE”.“ST_SPATIAL_INDEX” PARAMETERS (‘ST_GRIDS = 0 ST_SRID = 300004 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4’)
/
CREATE INDEX “SDE”.“A181_IX1” ON “SDE”.“站内变径” (“SHAPE”)
INDEXTYPE IS “SDE”.“ST_SPATIAL_INDEX” PARAMETERS (‘ST_GRIDS = 0 ST_SRID = 300004 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4’)
/

参考：
https://support.esri.com/en/technical-article/000010767
https://community.esri.com/thread/222335-ora-29861domain-index-is-marked-loadingfailedunusable