While trying to re-name a field in a layer in my ArcGIS 10.2 Enterprise Geodatabase hosted in Oracle Database, I faced the below error:

ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine 
ORA-20085: Insert Spatial Reference SRID 4326 does not match 
SDE.GDB_ITEMS.SHAPE registered Spatial Reference SRID 0 
ORA-06512: in “SDE.ST_DOMAIN_METHODS”, line 2000 
ORA-06512: in “SDE.ST_DOMAIN_METHODS”, line 2372

This error is related to ESRI bug NIM099594

Resolution:

SQL> SELECT index_name FROM user_ind_columns WHERE table_name = ‘GDB_ITEMS’ and column_name = ‘SHAPE’;

The Previous query will list for you the index associated with GDB_ITEMS table.

 

 

Then use the “drop” command to drop the index

SQL> DROP INDEX A8709_IX1;

Index dropped

 

For More information about this bug, check the following link resources:

http://support.esri.com/en/knowledgebase/techarticles/detail/42335

http://support.esri.com/en/bugs/nimbus/TklNMDk5NTk0