RANGE分区表合并分区.docVIP

RANGE分区表合并分区 【实验】【PARTITION】RANGE分区表合并分区 个人分类：性能优化 1.创建测试用range分区表 sec@ora10g create table t_partition_range (id number,name varchar2(50)) 2 partition by range(id)( 3 partition t_range_p1 values less than (10) tablespace tbs_part01, 4 partition t_range_p2 values less than (20) tablespace tbs_part02, 5 partition t_range_p3 values less than (30) tablespace tbs_part03, 6 partition t_range_pmax values less than (maxvalue) tablespace tbs_part04); Table created. 2.查询分区情况 sec@ora10g col TABLE_NAME for a20 sec@ora10g col partition_name for a20 sec@ora10g col HIGH_VALUE for a10 sec@ora10g col TABLESPACE_NAME for a15 sec@ora10g select table_name,partition_name,high_value,tablespace_name from user_tab_partitions where table_name=T_PARTITION_RANGE order by partition_position; TABLE_NAME PARTITION_NAME HIGH_VALUE TABLESPACE_NAME -------------------- -------------------- ---------- --------------- T_PARTITION_RANGE T_RANGE_P1 10 TBS_PART01 T_PARTITION_RANGE T_RANGE_P2 20 TBS_PART02 T_PARTITION_RANGE T_RANGE_P3 30 TBS_PART03 T_PARTITION_RANGE T_RANGE_PMAX MAXVALUE TBS_PART04 3.每个分区各插入一条数据 sec@ora10g insert into T_PARTITION_RANGE values (9,secooler01); 1 row created. sec@ora10g insert into T_PARTITION_RANGE values (19,secooler02); 1 row created. sec@ora10g insert into T_PARTITION_RANGE values (29,secooler03); 1 row created. sec@ora10g insert into T_PARTITION_RANGE values (39,secooler04); 1 row created. sec@ora10g commit; Commit complete. 4.确认每个分区包含的数据 sec@ora10g select * from T_PARTITION_RANGE partition(T_RANGE_P1); ID NAME ---------- -------------------------------------------------- 9 secooler01 sec@ora10g select * from T_PARTITION_RANGE partition(T_RANGE_P2); ID NAME ---------- -------------------------------------------------- 19 secooler02 sec@ora10g select * from T_PARTITION_RANGE partition(T_RANGE_P3); I