| Bug Number | BUG-000091547 |
| Submitted | Oct 20, 2015 |
| Modified | Jun 11, 2020 |
| Severity | Medium |
| Applies To | ArcSDE/Enterprise Geodatabase |
| Version Found | 10.2.1 |
| Prog Language | N/A |
| Server Platform | |
| Client Platform | |
| Database | Oracle |
| Locale | N/A |
| Status | Not in Current Product Plan |
| Version Fixed | |
| SP Fixed |
Bug BUG-000091547
Synopsis
Rebuild spatial index function on feature class property window failed with the following error, "Failed to add spatial index No shape selected or used".
Additional Information
Duplicate of NIM035228: See the KB article http://support.esri.com/en/knowledgebase/techarticles/detail/34984 The restored GDB provided by the customer was created Pre 9.2, upgraded later and contains a oracle generated type oid instead of default 'A618FA8DD1D84E13B35784E171530100'. The data was created using an antiquated st_geometry type. Upgrade does not (cannot) address this issue. There is no way to alter type set OID. This issue was addressed at 9.2 SP6/9.3. So, the only possible workaround to fix the data is: On a clean Oracle instance: - perform a fresh install of the SDE.ST_GEOMETRY type (enable or create GDB) with a current release of the software. - copy/paste the data from this instance using ArcGIS Desktop.