Upgrade the ST_Geometry type in an Oracle database

You can upgrade the ST_Geometry type in your Oracle database using the Create Spatial Type geoprocessing tool or a Python script.

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. Install a new release of the ArcGIS client to obtain the new version of the st_shapelib library.
3. Make a backup copy of or rename the existing st_shapelib library on the Oracle server.
4. Copy the new libst_shapelib (st_shapelib for Windows) library from the DatabaseSupport directory in the ArcGIS client installation location and place it 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. Start ArcCatalog or ArcMap and open the Catalog window.
6. Create a connection to your Oracle database. Log in as an Oracle sys database administrator.
7. Open the Create Spatial Type tool.

   You can use the Search window to search for the tool or open the tool from the Workspace toolset of the Data Management toolbox.

8. Add the database connection you created in step 6 to the Database Connection File text box.
9. Click OK to run the tool.

The ST_Geometry type, subtypes, and functions are now upgraded to the latest release.