Bug
DDL statement within st_geom_cols_util package body causes spx_util to become invalid through Oracle object dependency when using the Spatial Type for Oracle.
| Bug ID Number | NIM014024 |
|---|---|
| Submitted | December 31, 2007 |
| Last Modified | June 5, 2024 |
| Applies to | No Product Found |
| Version found | 9.3 |
| Version Fixed | 9.3 |
| Status | Fixed |
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.Steps to Reproduce
Bug ID: NIM014024
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App