Bug: Applying a spatial filter on a view created with sdetable in Oracle returns "ORA-00918: column ambiguously defined"
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.