BUG

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

Last Published: April 25, 2020

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.

    Article ID:000009824

    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