Oracle分区表
-- 查询分区的表
select table_name,partition_name from user_tab_partitions where table_name='TB_PARTBYMONTH';
-- 修改分区名
ALTER TABLE TB_PART3_TEST01 RENAME PARTITION TB_PART_TEST01_PT3 TO PART3;
-- 创建分区表
CREATE TABLE TB_PARTBYMONTH (
ID NUMBER(38,0) PRIMARY KEY NOT NULL,
RC_DATE DATE
) PARTITION BY RANGE (RC_DATE) INTERVAL ( NUMTOYMINTERVAL (1, 'MONTH') )
(PARTITION PART1 VALUES LESS THAN (TO_DATE('2019-02-1', 'yyyy-mm-dd')), --1
PARTITION PART2 VALUES LESS THAN (TO_DATE('2019-03-1', 'yyyy-mm-dd')), --2
PARTITION PART3 VALUES LESS THAN (TO_DATE('2020-01-1', 'yyyy-mm-dd')) --3~12
);
-- 查询分区表的数据
select * from TB_PARTBYMONTH;
-- 查询指定分区的数据
select * from TB_PARTBYMONTH partition(PART1);
select * from TB_PARTBYMONTH partition(PART2);
select * from TB_PARTBYMONTH partition(PART3);