topic Re: SDE 9.3.1 Compress Error in Data Management Questions https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46108#M2597 <HTML><HEAD></HEAD><BODY><SPAN>What version of Oracle are you using?</SPAN><BR /><BR /><SPAN>What geometry storage type are you using?</SPAN><BR /><BR /><SPAN>Are you using partitioning?</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 12 Jul 2012 17:24:01 GMT VinceAngelo 2012-07-12T17:24:01Z SDE 9.3.1 Compress Error https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46107#M2596 <HTML><HEAD></HEAD><BODY><SPAN>We are getting an error during compression: </SPAN><BR /><BR /><SPAN>ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Underlying DBMS error [ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE</SPAN><BR /><SPAN>] [SDE.DEFAULT]</SPAN><BR /><SPAN>Failed to execute (Compress).</SPAN><BR /><BR /><SPAN>Any Ideas?</SPAN></BODY></HTML> Thu, 12 Jul 2012 17:00:47 GMT https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46107#M2596 brianscholl 2012-07-12T17:00:47Z Re: SDE 9.3.1 Compress Error https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46108#M2597 <HTML><HEAD></HEAD><BODY><SPAN>What version of Oracle are you using?</SPAN><BR /><BR /><SPAN>What geometry storage type are you using?</SPAN><BR /><BR /><SPAN>Are you using partitioning?</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 12 Jul 2012 17:24:01 GMT https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46108#M2597 VinceAngelo 2012-07-12T17:24:01Z Re: SDE 9.3.1 Compress Error https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46109#M2598 <HTML><HEAD></HEAD><BODY><SPAN>Oracle 11.2.0.3&nbsp; Windows 2008R2 64-bit</SPAN><BR /><BR /><SPAN>SDO Geometry.</SPAN><BR /><BR /><SPAN>No Partitioning.</SPAN></BODY></HTML> Thu, 12 Jul 2012 18:21:45 GMT https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46109#M2598 brianscholl 2012-07-12T18:21:45Z Re: SDE 9.3.1 Compress Error https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46110#M2599 <HTML><HEAD></HEAD><BODY><SPAN>Google on the ORA-29861 error.&nbsp; It's been too long to remember the details, but the</SPAN><BR /><SPAN>SDO_GEOMETRY index can get in a strange state where the index is corrupt, so you</SPAN><BR /><SPAN>can't rebuild it and you can't drop it either.&nbsp; There's a workaround where you hack</SPAN><BR /><SPAN>the index metadata table, then drop the index; from there you can rebuild it.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 12 Jul 2012 18:29:56 GMT https://community.esri.com/t5/data-management-questions/sde-9-3-1-compress-error/m-p/46110#M2599 VinceAngelo 2012-07-12T18:29:56Z