分区表修改默认表空间

 /* Formatted on 2019/5/26 下午 02:17:42 (QP5 v5.163.1008.3004) */
  SELECT DISTINCT
            ‘alter table ‘
         || a.owner
         || ‘.‘
         || a.segment_name
         || ‘ modify default attributes tablespace D_MLBII_TRACK;‘ ,SUM (bytes) / 1024 / 1024 / 1024
    FROM DBA_SEGMENTs a,
         (SELECT DISTINCT OWNER, TABLE_NAME
            FROM DBA_PART_TABLES
           WHERE DEF_TABLESPACE_NAME = ‘I_ATEST_RESULT_DATA‘) b
   WHERE a.owner = b.owner AND a.SEGMENT_NAME = b.table_name
GROUP BY a.owner, a.segment_name
ORDER BY SUM (bytes) / 1024 / 1024 / 1024 DESC