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


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.

Alternate Solution