gis报错ORA-29861

最新推荐文章于 2025-02-18 22:55:41 发布

原创最新推荐文章于 2025-02-18 22:55:41 发布 · 444 阅读

1 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了如何在Oracle数据库中检查索引的状态，特别是针对标记为'INPROGRESS'的DOMAIN类型索引。提供了查询索引状态、获取创建DDL、删除及重建索引的具体SQL语句，并附带了相关ESRI支持文档链接。

查看索引状态：

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