Arcsde报ora-29861: 域索引标记为loading/failed/unusable错误

 

                try
                {
                    isSDEEdit = pWorkspaceEditSDE.IsBeingEdited();
                    if (isSDEEdit)
                    {
                        pWorkspaceEditSDE.StopEditOperation();
                        pWorkspaceEditSDE.StopEditing(true);
                    }
                }
                catch (COMException comExc)
                {
                    if (comExc.ErrorCode == (int)fdoError.FDO_E_VERSION_REDEFINED)
                    {
                        pWorkspaceEditSDE.AbortEditOperation();
                        pWorkspaceEditSDE.StopEditing(false);
                    }
                    else
                    {
                        pWorkspaceEditSDE.AbortEditOperation();
                        pWorkspaceEditSDE.StopEditing(false);
                    }
                }

 

连接数据库的软件在编辑要素时突然报出这个错误:

 解决方法很简单,找出错误索引,再删除这个错误索引.

先执行

select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID'; 

找出所有错误的,然后删除它们

 drop index 错误的索引名;