ERROR

Oracle ora-14016 error encountered when creating a spatial index or feature class

Last Published: April 25, 2020

Error Message

Creating a feature class or a spatial index (st_spatial_index) on an st_geometry attribute in Oracle encounters the following error:

"Underlying DBMS error [Error executing PL/SQL Block db_stgeom_create_index::ORA-14016: underlying table of a LOCAL partitioned index must be partitioned]".

Cause

The ArcSDE dbtune parameter, ST_INDEX_PARTITION_LOCAL, has been set to true and the table containing the st_geometry attribute for which the spatial index is being created is not partitioned.

Creating a local partitioned spatial index (a spatial index for each partition in the table) requires the table to be partitioned.

Solution or Workaround

To avoid the error, the ArcSDE dbtune parameter ST_INDEX_PARTITION_LOCAL value must be set to false. Use the ArcSDE sdedbtune command as the ArcSDE administrator to alter the value from true to false.

Code:
D:\>sdedbtune -o alter -i 5151 -k DEFAULTS -P st_index_partition_local -v false -u sde -p sde -N

ArcSDE 9.3 for Oracle11g Build 508 Thu Apr 17 12:23:18 2008
Attribute Administration Utility
-----------------------------------------------------

Successfully altered dbtune data.


The (-k) argument specifies the keyword containing the parameter, the (-P) argument is the parameter name to modify, and the (-v) argument is the new value to set for the parameter being altered.

    Article ID:000010060

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic