English

How To: Control the storage of the st_spatial_index table in Oracle with ArcGIS

Summary

To control the storage options for the ST_Geometry attribute's st_spatial_index set the storage clause for the keyword's S_STORAGE parameter.

ArcSDE searches the DBTUNE table for the parameter name-configuration string pairs associated with the specified configuration keyword. The necessary configuration strings are incorporated in the CREATE TABLE or CREATE INDEX statement that ArcSDE submits to the database.

For example, if creating a new feature class in ArcCatalog by right-clicking a geodatabase stored in Oracle, pointing to New, and then clicking Feature Class; the New Feature Class dialog box provides the opportunity to specify a configuration keyword to use for creating the new feature class.

When creating a new feature class in ArcGIS that uses the ST_Geometry attribute in Oracle, the S_STORAGE parameter is used in defining the storage characteristics for the spatial index. The spatial index is a table named S<n>_IDX$, where <n> is the geometry index value. The table is created as an Oracle Indexed Organized Table (IOT).

Procedure

To control and define the storage characteristics of the ST_Geometry_Index in the ArcSDE DBTUNE table, first export the table to a file using the ArcSDE sdedbtune command.

Next, using a text editor, edit the S_STORAGE parameter's storage clause by setting the appropriate storage options. The configuration string can control the tablespace where the table will be created and the table's storage characteristics, initial extent, next extent, etc.

The following is an example DBTUNE file for the S_STORAGE parameter and configuration string:

S_STORAGE "TABLESPACE spatial_idx STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0)"


    Related Information