修改某表分区 增加子分区
---T_xxxx ---
SELECT t.partition_name FROM USER_TAB_PARTITIONS t WHERE t.TABLE_NAME = 'T_xxxx' //查询主分区
SELECT * FROM USER_TAB_SUBPARTITIONS where TABLE_NAME = 'T_xxxx ' and partition_name='T_xxxx _20170101'; //已知表名和主分区 查子分区
ALTER TABLE T_xxxx MODIFY PARTITION T_xxxx 20170101 add SUBPARTITION S_20161231 values ('20161231');
ALTER TABLE T_xxxx MODIFY PARTITION T_xxxx _20170101 add SUBPARTITION S_20161201 values ('20161201');
可惜我不会写删除子分区语句
自动建分区 可以写成存储过程跑