Is This Content Helpful?
We're glad to know this article was helpful.
Copying a feature class from one ArcSDE SDO_GEOMETRY feature class to another converts features with NULL geometry to features with NIL geometry. ArcSDE represents NIL geometries in Oracle Spatial feature classes as "SDO_GEOMETRY(NULL, NULL, NULL, NULL, NULL)". ArcSDE represents NULL feature as simply a NULL in the SDO_GEOMETRY column.
Oracle’s geometry validation function SDO_UTIL.VALIDATE_GEOMETRY_WITH_CONTEXT reports both of these representations as NULL.
This is a known issue. It is fixed in ArcSDE 9.2 SP1.
After copying feature a feature class, update the features from NIL to NULL using SQL, assuming that the features to be updated can be identified by their attribute columns.