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

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic