Rebuild spatial index function on feature class property window failed with the following error, "Failed to add spatial index No shape selected or used".
Last Published: October 27, 2015ArcSDE/Enterprise Geodatabase
Bug ID Number
October 20, 2015
June 11, 2020
The issue is a duplicate of an existing issue. See the issue's Additional Information section for details. Customers associated with the duplicate issue are automatically attached to the open issue.
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.