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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options