Is This Content Helpful?
We're glad to know this article was helpful.
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.
Create a spatial index on the st_geometry attribute and perform the rename operation. If required, drop the spatial index after performing the rename operation.