Oracle-TableSpace

SELECT owner, segment_name, partition_name, tablespace_name , 'ALTER TABLE '||a.segment_name||' move PARTITION '||a.partition_name||' tablespace TESTD ......