HOW TO
Instructions provided describe how to rename the ST_Geometry points' LOB segment.
If the LOB segment name is not specified during the creation of the ST_Geometry attribute, the LOB segment name is created automatically by Oracle. Without an identifiable name, it may be difficult to identify which LOB segments are impacted by performance. By providing a LOB segment name, the user controls the naming convention and can specify a name that relates to the table name.
Code:
SQL> ALTER TABLE streets
2 MOVE LOB(shape.points) STORE AS streets_lob_seg;
Table altered.
Code:
SQL> SELECT index_name, status
2 FROM user_indexes
3 WHERE table_name = 'STREETS';
INDEX_NAME STATUS
------------------------------ --------
STREET_NAME_IDX UNUSABLE
R45_SDE_ROWID_UK UNUSABLE
SYS_IL0000346092C00038$$ VALID
A9_IX1 UNUSABLE
Code:
SQL> ALTER INDEX street_name_idx REBUILD;
Note:
See Oracle's documentation for additional information.
Get help from ArcGIS experts
Download the Esri Support App