Bug: Applying a Spatial Filter on a View Created with Sdetable in Oracle Returns "ORA-0091

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

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

Description

Cause

Workaround

Discover more on this topic