Upgrade the ST_Geometry type in an Oracle database

The ST_Geometry library can contain new functionality or fixes at each ArcGIS release. You can upgrade the ST_Geometry type in your Oracle database using the Create Spatial Type geoprocessing tool or the CreateSpatialType ArcPy function.

Steps:
  1. Grant the following privileges to the sde user if it does not already have them:

    • CREATE SESSION
    • CREATE TABLE
    • CREATE VIEW
    • CREATE PROCEDURE
    • CREATE SEQUENCE
    • CREATE TRIGGER
    • CREATE TYPE
    • CREATE INDEXTYPE
    • CREATE LIBRARY
    • CREATE OPERATOR
    • CREATE PUBLIC SYNONYM
    • DROP PUBLIC SYNONYM
    • ADMINISTER DATABASE TRIGGER

  2. Download a new version of the st_shapelib (Windows) or libst_shapelib (Linux) from My Esri.
  3. Make a backup copy of or rename the existing st_shapelib (Windows) or libst_shapelib (Linux) library on the Oracle server.
  4. Place the new library in the same on the Oracle server where you had placed the old library originally.

    If you place it in a new location, you will have to update the library definition in Oracle. Be sure to use the library appropriate for your Oracle server operating system.

  5. Using one of the following, create a database connection file, connecting to the database as an Oracle sys database administrator.
    • Open an ArcGIS Pro project and create a database connection from the Catalog pane.
    • Start ArcCatalog or ArcMap and create a database connection from the Catalog window.
    • Run the CreateDatabaseConnection Python function.
  6. To update the ST_Geometry type, subtypes, and functions in the database, run the Create Spatial Type geoprocessing tool or a Python script that uses the CreateSpatialType function and the .sde file you created in the last step.
Copyright © 1995-2017 Esri. All rights reserved.