BUG
Renaming a table in Oracle with ArcCatalog, which contains a st_geometry attribute without a spatial index, fails with the following underlying DBMS error:
"ORA-01403: no data found".
When the rename operation is performed, ArcSDE calls the sde.st_geom_cols_util.update_gcol_table procedure to update metadata in the sde.st_geometry_columns and sde.st_geometry_index tables. When no index is present on the st_geometry attribute, a cursor querying the st_geometry_index table returns no rows, causing the operation to fail.
Get help from ArcGIS experts
Download the Esri Support App