Daily Archives: January 3, 2015

Move a partitioned table from one tablespace to another tablespaces


select ‘ALTER TABLE ‘||TABLE_OWNER ||’.’||table_name||’ MOVE PARTITION ‘||partition_name||’ TABLESPACE tbs_NEW PARALLEL(DEGREE 4) NOLOGGING;’ from dba_tab_partitions where TABLESPACE_NAME = ‘tablespace_old’; Advertisements