MOVE LOBS

--moving the table to the new tablespace
alter table table_name move tablespace new_tablespace;
 
--rebuilding the index(es) and moving them to the new tablespace
alter index index_name rebuild tablespace new_tablespace;
 
--moving the lobsegment(s) to the new tablespace
alter table table_name move lob (lob_column) store as
(tablespace new_tablespace);
 
--shrinking the table and lobsegment
alter table table_name enable row movement;
alter table table_name shrink space cascade;
alter table table_name modify lob (lob_column) (shrink space);

Leave Comment

Your email address will not be published. Required fields are marked *