Incorrect variable assignment in st_type_export.validate_spref prevents user schemas from being imported correctly without errors

Last Published: April 25, 2020


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.


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.


Currently there is no workaround to the problem.

    Article ID:000009904

    • 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