alter table TMS_BILL_TASK
set subpartition template(=============新的分区信息 );
更改子分区信息:
alter table "HAIERTMS"."TMS_BILL_TASK" modify subpartition SYS_SUBP4833 add values(10411);
查询子分区信息:
select table_name,partition_name,high_value,tablespace_name,SUBPARTITION_COUNT from dba_tab_partitions
select TABLE_NAME,partition_name,SUBPARTITION_NAME,HIGH_VALUE,HIGH_VALUE_LENGTH from dba_tab_subpartitions