Is This Content Helpful?
We're glad to know this article was helpful.
Renaming a layer with an ST_Geometry attribute in ArcCatalog causes the sde.spx_util package to become invalid; therefore, further operations by the session and potentially other connected sessions will encounter underlying Oracle errors.
When a table with an ST_Geometry attribute is renamed, the sde.spx_util becomes invalid because a constraint on the sde.st_geometry_columns table is being disabled and enabled by the sde.st_geom_cols_util package.
If a layer with an ST_Geometry attribute must be renamed, it is best to rename the layer when no other users are connected. Once the layer has been renamed, exit ArcCatalog and resume operations.