Is This Content Helpful?
We're glad to know this article was helpful.
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(+)"
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.