--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);
Related