English

Bug: Renaming a layer with an ST_Geometry attribute causes the spx_util package to become invalid

Description

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.

Cause

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.

Workaround

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.