BUG

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

Last Published: April 25, 2020

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.

    Article ID:000009829

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic