English

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

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.