The partition table changes the default tablespace and moves existing partitions to the specified table space

1, modify the default table space of the partition table:
Select ' ALTER TABLE ' | | table_name| | ' Modify default attributes Tablespace TSDAT01 ' from Dba_tables where table_name in (' T ');


Query-out statements executed directly
2. Move existing partitions to other table spaces
Begin
For x in (select Table_owner,table_name,partition_name to Dba_tab_partitions where table_name in (' T '))
Loop
Execute immediate ' ALTER TABLE ' | | x.table_owner| | '. ' | | x.table_name| | ' Move Partition ' | | X.partition_name | | ' Tablespace users ';
End Loop;
End
/