topic Oracle SDE ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE in Data Management Questions https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496583#M28206 <HTML><HEAD></HEAD><BODY><SPAN>I've been getting this error for 3 days. I haven't been able to alter the class at all. We're rebooted all servers, including DB, tried rebuilding indexes, even tried deleting indexes.</SPAN></BODY></HTML> Tue, 22 Mar 2011 11:16:10 GMT KyleDixon 2011-03-22T11:16:10Z Oracle SDE ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496583#M28206 <HTML><HEAD></HEAD><BODY><SPAN>I've been getting this error for 3 days. I haven't been able to alter the class at all. We're rebooted all servers, including DB, tried rebuilding indexes, even tried deleting indexes.</SPAN></BODY></HTML> Tue, 22 Mar 2011 11:16:10 GMT https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496583#M28206 KyleDixon 2011-03-22T11:16:10Z Re: Oracle SDE ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496584#M28207 <HTML><HEAD></HEAD><BODY><SPAN>This is a chicken-egg kind of error from Oracle. A shutdown/restart won't change the</SPAN><BR /><SPAN>metadata which generates a 29861 error. You can often delete the index by using the </SPAN><BR /><SPAN>FORCE option of "DROP INDEX".</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Tue, 22 Mar 2011 13:57:09 GMT https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496584#M28207 VinceAngelo 2011-03-22T13:57:09Z Re: Oracle SDE ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496585#M28208 <HTML><HEAD></HEAD><BODY><SPAN>I was able to fix it by:</SPAN><BR /><SPAN>RemoveSpatialIndex_management("Database Connections/ARCSDE.sde/[Offending table]")</SPAN><BR /><SPAN>AddSpatialIndex_management("Database Connections/ARCSDE.sde/[Offending table]","75000","0","0")</SPAN></BODY></HTML> Tue, 22 Mar 2011 14:12:52 GMT https://community.esri.com/t5/data-management-questions/oracle-sde-ora-29861-domain-index-is-marked/m-p/496585#M28208 KyleDixon 2011-03-22T14:12:52Z