laptop and a wrench

Bug

Using Oracle expdp to export sde schema will generate an error about st_spatial_index on gdb_items table if the database NLS settings are set to GERMAN and OS regional settings are also GERMAN and there is at least one feature classes stored with ST_GEOMETRY data type.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM062511
SubmittedNovember 3, 2010
Last ModifiedApril 28, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.0
Operating SystemWindows OS
Operating System Version2008 64 Bit
Version FixedN/A
StatusFixed

Workaround

A possible workaround would be dropping the index before export the schema, and then recreating/recalculating the index after import.This will have to be done for every single st_geometry table that has a spatial index with multiple grids that include decimal places.

Steps to Reproduce

Bug ID: NIM062511

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options