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, 2014No Product Found
Bug ID Number
NIM012658
Submitted
October 30, 2007
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.2
Version Fixed
9.3
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
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.