表:
alter table_name move tablespace new_tablespace;
重建索引
表分区:
ALTER TABLE PART_TAB MOVE PARTITION "P_412823" TABLESPACE "HROLTPDATA412823" UPDATE INDEXES;索引:
alter index indexname rebuild online;
LOB:
alter table table_name move tablespace tablespace_name lob (col_lob1,col_lob2) store as(tablesapce target_tablespace_name) update indexes;