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