How To: Move the ST_Geometry points' Oracle LOB segment to a new tablespace
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.
A LOB segment can be moved from one tablespace to another using Oracle's ALTER TABLE command.
SQL> ALTER TABLE streets
2 MOVE LOB(shape.points) STORE AS(TABLESPACE lob_seg_tbs);
The above example demonstrates moving the streets table's LOB segment named shape.point from its existing tablespace to the lob_seg_tbs tablespace.
After moving an object it is recommended to gather new table statistics. See Oracle's documentation for additional information.