laptop and a wrench

Bug

Spatial Type for Oracle: Recreating a feature class with the same name as an old, dropped feature class can cause spatial queries to fail.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM012658
SubmittedOctober 30, 2007
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.2
Version Fixed9.3
StatusFixed

Workaround

This happens because no row is inserted into SDE.ST_GEOMETRY_INDEX if there is a preexisting row for the same feature class name in SDE.ST_GEOMETRY_COLUMNS.Use sde.st_geom_cols_util.delete_gcol to delete the metadata for the table in SDE.ST_GEOMETRY_COLUMNS before creating the spatial index.

Steps to Reproduce

Bug ID: NIM012658

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options