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…
