Applying a spatial filter on a view created with sdetable in Oracle returns "ORA-00918: column ambiguously defined"

Last Published: April 25, 2020


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.

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.


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.


Currently there is no workaround that addresses this issue.

    Article ID:000009824

    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options