BUG
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(+)"
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.
Get help from ArcGIS experts
Download the Esri Support App