laptop and a wrench


The Find and Replace function returns an error, "ORA-00904" when searching for a value in a feature class with SDO_GEOMETRY.

Last Published: April 8, 2016 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085945
SubmittedMarch 9, 2015
Last ModifiedJune 11, 2020
Applies toArcSDE/Enterprise Geodatabase
Version found10.2
Operating SystemWindows
Operating System Version7 64 Bit
StatusWill Not Be Addressed

Additional Information

SDO_Geometry data type does not contain the columns of shape.len and shape.area. However these columns are needed by ArcGIS for consistency. Please exclude these columns from calculations or searches.



Steps to Reproduce

Bug ID: BUG-000085945


  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic