English

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

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.

    Related Information