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…