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
BUG-000091547
Submitted
October 20, 2015
Last Modified
June 11, 2020
Applies to
ArcSDE/Enterprise Geodatabase
Version found
10.2.1
Status
Duplicate
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.
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.