Move partition to new tablespace - oracle database script

- MOVE a single PARTITION TO a NEW TABLESPACE
ALTER TABLE SCOTT.EMP MOVE PARTITION EMP_Q1 TABLESPACE TS_USERS; --- Move a single partition to a new tablespace WITH PARALLEL  ALTER TABLE SCOTT.EMP MOVE PARTITION EMP_Q1 TABLESPACE TS_USERS PARALLEL(DEGREE 4) NOLOGGING;  - Dynamic script to move all partitions of a table  select 'ALTER TABLE '||TABLE_OWNER ||'.'||table_name||' MOVE PARTITION '||partition_name||' TABLESPACE TS_USERS PARALLEL(DEGREE 4) NOLOGGING;' from dba_tab_partitions where table_name='&TABLE_NAME' and table_owner='&SCHEMA_NAME';