Do not export a table's secondary object (st_spatial_index) when a table with an st_geometry attribute is exported with Oracle's export utilities in Spatial Type for Oracle.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM032562
Submitted
February 25, 2008
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.3
Version Fixed
9.3
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
Description
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.
Cause
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.
Workaround
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.