Bug
Unable to rename a table with an st_geometry attribute, when using Spatial Type for Oracle, which does not have an st_spatial_index present.
| Bug ID Number | NIM032091 |
|---|---|
| Submitted | February 12, 2008 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 Beta 1 |
| Version Fixed | 9.3 |
| Status | Fixed |
Description
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".
Cause
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.Workaround
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.Steps to Reproduce
Bug ID: NIM032091
Software:
- No Product Found
Get notified when the status of a bug changes
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App