The st_geometry spatial index is exported when using Oracle export utilities

Last Published: April 25, 2020


When performing an Oracle export with the Export utility or Data Pump, and exporting a table containing an st_geometry attribute with an st_spatial_index, the index is exported.

With ArcGIS 9.2, when the export is performed, the st_geometry attribute's spatial index is exported, and during the import operation, the index is imported.


The ESRI st_geometry implementation defines the behavior of how the st_geometry attribute, spatial index, and metadata is handled during an Oracle export operation. This implementation is limited by the fact that Oracle's Object Extensibility documentation does not describe how to avoid exporting a secondary table object (the st_geometry's st_spatial_index object) during an Oracle export. This limitation means that the st_spatial_index object is unavoidably exported by default, if it exists.


Drop the st_geometry attribute's st_spatial_index prior to performing the Oracle export operation. This simplifies the Oracle import process. Once the data is imported in the Oracle instance, build the spatial index.

Article ID:000010083

  • Legacy Products

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

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options