ORACLE删除分区表空间

 select 'alter table '|| table_name ||' drop partition '|| partition_name ||';' 
   from  dba_tab_partitions where  table_owner='' AND PARTITION_NAME LIKE 'P_2014%'