HOW TO

Move the ST_Geometry points' Oracle LOB segment to a new tablespace

Last Published: April 25, 2020

Summary

If the tablespace storage option was not specified during the creation of the ST_Geometry attribute, the LOB segment is automatically created in the user's default tablespace. This may not be the optimial location, making it necessary to move the LOB segment to a new tablespace.

Instructions provided describe how to move the ST_Geometry points' LOB segment to a new tablespace.

Procedure

A LOB segment can be moved from one tablespace to another using Oracle's ALTER TABLE command.

Code:
SQL> ALTER TABLE streets
2 MOVE LOB(shape.points) STORE AS(TABLESPACE lob_seg_tbs);

Table altered.



The above example demonstrates moving the streets table's LOB segment named shape.point from its existing tablespace to the lob_seg_tbs tablespace.

Note:
After moving an object it is recommended to gather new table statistics. See Oracle's documentation for additional information.

    Article ID:000009510

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options