laptop and a wrench

Bug

When importing a table uisng Spatial Type or Oracle, Oracle's import utility may fail with Oracle error ORA-20091.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM032090
SubmittedFebruary 12, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3 Beta 1
Version Fixed9.3
StatusFixed

Description

When using Oracle's Data Pump Import utility with the option to import an entire schema, which includes tables with st_geometry attributes and spatial indexes, the Oracle error ORA-20091 may occur.

Cause

Using the Oracle Data Pump Import utility or the original import utility, the Oracle error ORA-20091 may occur.

The reason of the cause is an invalid variable assignment within st_type_export.validate_spref.

This is a specific problem introduced in ArcGIS 9.2 Service Pack 5.

Workaround

Currently there is no workaround to the problem.

    Steps to Reproduce

    Bug ID: NIM032090

    Software:

    • No Product Found

    Get notified when the status of a bug changes

    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