Bug
Geometry cannot be displayed in ArcGIS when a view is created from a join between a featureclass stored as ST_GEOMETRY and a simple table.
| Bug ID Number | NIM010579 |
|---|---|
| Submitted | July 25, 2007 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Version Fixed | 9.3 |
| Status | Fixed |
Description
Applying a spatial filter on a view created with sdetable returns the following error:"ORA-00918: column ambiguously defined".
This may happen when a view is created with sdetable -o create_view when two tables are joined in the view's definition.
Code:
sdetable -o create_view -T land_view -t parcels,land -c parcels.objectid,parc
els.shape,parcels.parid,land.taxyr,land.ltype,land.parid -w "parcels.parid=land.parid(+)"
When the view is added to ArcMap and the session zooms into an area (performing a spatial query), an underlying Oracle error is encountered.
Cause
Internally, ArcSDE generates a query with an invalid attribute that is not fully qualified to reference one of the two tables defined in the view.Workaround
Currently there is no workaround that addresses this issue.Steps to Reproduce
Bug ID: NIM010579
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