HOW TO
Instructions provided describe how to move an st_geometry attribute's spatial index to a new tablespace. Reasons that may force the movement of a spatial index to a new tablespace could be space management or resource contention between multiple segments on the same physical disk.
To move a spatial index between tablespaces, use the Oracle ALTER TABLE command in SQL*Plus.
Code:
SQL> SELECT geom_id
2 FROM sde.st_geometry_columns
3 WHERE table_name = 'STREET'
4 AND owner = USER;
GEOM_ID
----------
102
Code:
SQL> ALTER TABLE s102_idx$ MOVE TABLESPACE strt_idx_tbs;
Table altered.
SQL> SELECT tablespace_name
2 FROM user_indexes
3 WHERE index_name = 'S102$_IX1';
TABLESPACE_NAME
------------------------------
STRT_IDX_TBS
Article ID: 000009505
Get help from ArcGIS experts
Download the Esri Support App