NIM038871 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM038871
Submitted	September 29, 2008
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.2
Operating System	IBM AIX
Operating System Version	53
Version Fixed	10
Status	Fixed

Additional Information

Fixed in release 10.0

Workaround

If comman tools is the only abailable tools to use:1. Use sdetable -o rebuild_index -x VERSIONED to rebuild A&D table indexes.2. Use sdetable -o delete/create_index to recreat attribute index on business table.3. Use sdelayer -o normal_io to rebuild the spatial index to substitue sdetable -o rebuild_index -x SPATIALIf ArcGIS desktop is available:(A) Updating spatial index:------------------------------In ArcCatalog, Right-mouse click on layer > Properties > Select Indexes Tab > Click on Delete button under Spatial Index section > Click on Recalculate button(B) Updating attribute index:----------------------------------In ArcCatalog, Right-mouse click on layer > Properties > Select Indexes Tab > Click on Add or Delete button under Attribute Indexes session.Note here that FID index can't be delete by GUI but "sdetable -o delete_index" allows to delete OBJECTID index.