ERROR
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]".
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.
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.
Article ID:000010060
Get help from ArcGIS experts
Download the Esri Support App