Cannot use datasets from Oracle 11g or Oracle 12c R1 with multiple geometry fields in Insights for ArcGIS

Last Published: April 25, 2020


Adding a dataset from an Oracle 11g or Oracle 12cR1 database will fail in Insights for ArcGIS if the dataset has multiple geometry fields and has multiple entries in USER_SDO_GEOM_METADATA view.


This failure is caused by an issue in Oracle 11g or Oracle 12c R1 databases.


Upgrade your Oracle database to a newer version.  For more information on which Oracle versions can be used with Insights, see Supported databases.

Article ID:000020718

  • ArcGIS Insights

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic