PROBLEM

Unable to create or install the Esri spatial type for Oracle (-521)

Last Published: April 25, 2020

Description

When attempting to create or install the Esri ST_Geometry spatial type, ERROR setting up ST_Geometry, Error = -521 occurs with the following error messages.

%TEMP%\GDBCreateGeodatabase<#>.log

Code:
[5/12/2011 5:12:44 PM] Error: Could not create geodatabase tables and stored procedures. [Failed to setup ST_Geometry type. (Unable to load Type ST_Geometry, underlying DBMS error encountered.)]
[5/12/2011 5:12:44 PM] Error: See the setup log in the following location for additional error information.
[5/12/2011 5:12:44 PM] Error: C:\Users\clint\AppData\Local\Temp\1\sde_setup.log


ArcSDE setup log (sde_setup.log)

Code:
[Thu May 12 17:12:38 2011] ERROR setting up ST_Geometry type.
[Thu May 12 17:12:38 2011] ERROR setting up St_Geometry, Error = -521

Cause

In Oracle, if a table exists that has a column type of PUBLIC.ST_GEOMETRY, the creation of the Esri SDE.ST_GEOMETRY type fails.

Solution or Workaround

Find the tables that reference a PUBLIC.ST_GEOMETRY column and drop them.

  1. Find the tables that reference a PUBLIC.ST_GEOMETRY column.

    Code:
    sqlplus sys/manager as sysdba

    set pages 9999

    SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NA
    ME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE='TABLE';

    OWNER NAME TYPE
    --------------------------- ------------------------------ ------------------
    MAP TEST TABLE

  2. Drop the table found in Step 1.

    Note:
    If the table is needed for any reason, backup the table before dropping it. This table can be restored after Esri ST_Geometry is installed.


    Code:
    drop table map.test;

  3. Purge the recycle bin.

    Code:
    purge dba_recyclebin;

  4. Re-run the install of the Esri ST_Geometry type.

Article ID: 000011268

Software:
  • 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