------查看各个用户下 分区数量
         SELECT T.TABLE_OWNER, COUNT(*)
           FROM DBA_TAB_PARTITIONS T
          WHERE LENGTH(PARTITION_NAME) = 12
            AND PARTITION_NAME LIKE 'PART%'
            AND PARTITION_NAME <= 'PART20150430'
          GROUP BY T.TABLE_OWNER