SELECT subpartition_name FROM USER_TAB_SUBPARTITIONS WHERE partition_name='P_201902' GROUP BY subpartition_name; 删除一下几个分区: alter table range_list_part_tab drop subpartition P_201902_P_591; alter table range_list_part_tab drop subpartition P_201902_P_592; alter table range_list_part_...
subpartitionbylist (STATE) ( partition Q1_2010valuesless than (100) tablespace TBS_INSIGHT_DEV pctfree10initrans1maxtrans255( subpartition Q1_2010_NORTHvalues('OR','WA') tablespace TBS_INSIGHT_DEV, subpartition Q1_2010_SOUTHvalues('AZ','UT','NM') tablespace TBS_INSIGHT_DEV ), partition Q2_...
ALTER TABLE list_part_tab MODIFY PARTITION P13 ADD SUBPARTITION P13SUB1 VALUES(350); 1. (3)删除分区 ALTER TABLE list_part_tab DROP PARTITION P13; 1. 删除子分区,子分区名称P13SUB1 ALTER TABLE list_part_tab DROP SUBPARTITION P13SUB1; 1. (4)TRUNCATE分区 TRUNCATE是指删除分区的数据,并不会删...
2 partition by range(id) subpartition by hash(name) 3 subpartition template ( 4 subpartition h1 tablespace tbspart01, 5 subpartition h2 tablespace tbspart02, 6 subpartition h3 tablespace tbspart03, 7 subpartition h4 tablespace tbspart04)( 8 partition t_r_p1 values less than (10) tablespace t...
SELECT * FROM salgrade SUBPARTITION(sp4); 3.5 列表分区 特点: -基于 PARTITION BY LIST 中指定的分区键对表进行分区 -明确地控制行到分区的映射 -指定分区键的离散值 ---创建销售表,将指定的销售人员进行分区,分为东部区域和西部区域--- CREATE TABLE sales_details ( sales_id...
PARTITION BY RANGE (order_date) SUBPARTITION BY LIST (state) ( PARTITION order_p1 VALUES LESS THAN (TO_DATE ('01-DEC-2015','DD-MON-YYYY'))READ ONLY ( SUBPARTITION order_p1_northwest VALUES ('OR', 'WA'), SUBPARTITION order_p1_southwest VALUES ('AZ', 'UT', 'NM')), ...
subpartition by list(C_COMP_CDE) ( partition P_2009_11 values less than (to_date('2009-12-01','yyyy-MM-dd')) ( subpartition P_2009_11_P1013 values('P1013') ) ); 六、表分区后的相关操作 1.添加分区 alter table T_TRACK add partition P_2005_04 ...
CREATE TABLE orders_read_write_only ( order_id NUMBER (12), order_date DATE CONSTRAINT order_date_nn NOT NULL, state VARCHAR2(2) ) READ WRITE PARTITION BY RANGE (order_date) SUBPARTITION BY LIST (state) ( PARTITION order_p1 VALUES LESS THAN (TO_DATE ('01-DEC-2015','DD-MON-YYYY')...
partition by 用于指定分区方式 range 表示分区的方式是范围划分 partition pn 用于指定分区的名字 values less than 指定分区的上界(上限) 添加分区: ALTER TABLE r add partition p5 values less than (xxx ) tablespace xx; 查看分区表相关信息: SELECT table_name,partition_name,subpartition_count, tablespace_...
by list (PART_ID) subpartition by hash (TEST_PRIMARYKEY_ID) ( partition P1 values (1) tablespace TAB_ARTISAN pctfree 10 initrans 1 maxtrans 255 ( subpartition P1_1 tablespace TAB_ARTISAN, subpartition P2_1 tablespace TAB_ARTISAN, subpartition P3_1 tablespace TAB_ARTISAN, subpartition P4_1 ...