English

How To: Create a local partitioned spatial index in Oracle with the dbtune

Summary

When creating a new feature class in ArcGIS and the objective is for the table to leverage Oracle partitioning, it may be necessary to set the ArcSDE dbtune parameter, ST_INDEX_PARTITION_LOCAL, to 'true' for creating a local spatial index for each partition.

To create a partitioned feature class in Oracle, see the following ESRI Knowledge Base article, "How to configure the ArcSDE DBTUNE for creating a partitioned table in Oracle".
<a href='http://support.esri.com/en/knowledgebase/techarticles/detail/34028' target='_blank'>How To: Configure the ArcSDE DBTUNE for creating a partitioned table in Oracle</a>

Procedure

To create the spatial index as a local index (a spatial index for each partition), the ArcSDE administrator must enable the ArcSDE dbtune parameter, ST_INDEX_PARTITION_LOCAL, to 'true' for the keyword used to create the feature class.

If the parameter does not exist for the specified keyword, the parameter must be created using the sdedbtune command:

Code:
D:\> sdedbtune -o insert -i 5151 -k DEFAULTS -P st_index_partition_local -v true -u sde -N

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

Successfully inserted dbtune data.

The (-k) argument specifies the keyword to insert the new parameter, the (-P) argument is the name of the parameter, and the (-v) argument is the value for the parameter being inserted.