Upgrade the ST_Geometry type in an Oracle database

Available with Standard or Advanced license.

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

Note:

The ST_Geometry library requires the Microsoft Visual C++ Redistributable Package (x64) when deployed on a Microsoft Windows server. See ArcGIS requirements for Oracle for the package version required. If this package is not present on the server, download it from the Microsoft site and install it.

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) library 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 location on the Oracle server where you placed the old library originally.

   If you place the library in a new location, you must update the library definition in Oracle. Use the library appropriate for your Oracle server operating system.

5. Open a project in ArcGIS Pro, open the Catalog pane, and connect to the database as an Oracle sys database administrator.

   This creates an .sde file in the project folder.

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 ArcPy function.

   Use the .sde file you created in the previous step for the database connection.