21.png (93.9 KB, 下载次数: 5)
2019-12-11 11:27 上传
如图所示。这是创建表格时的语句。已经有子分区模板了。(环境:ORACLE11.2.0.4)
我现在添加子分区时,不知道如何套用子分区模板,请各位大牛帮忙看下。
我是采用很土的方法添加,需要8条如下语句:
Alter table coll_cust_balance_data modifypartition p_customer_num_1 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_2 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_3 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_4 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_5 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_6 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_7 add subpartition month_2019_11 values(‘2019_11’);
Alter table coll_cust_balance_data modifypartition p_customer_num_8 add subpartition month_2019_11 values(‘2019_11’);
有没有语句可以直接添加?我百度了很久,就是百度不到。
Alter table coll_cust_balance_data add subpartitions month_2019_11 values(‘2019_11’);