Oracle分区信息（自用怕忘）

新建分区表

按照月份创建分区
create table DCS2
(
TAG_TIME DATE,
TAG_NAME VARCHAR2(200),
TAG_DESC VARCHAR2(200),
TAG_VALUE NUMBER
)
PARTITION BY RANGE (TAG_TIME) INTERVAL (numtoyminterval(1, ‘month’))
(partition DCS201912 values less than(to_date(‘2020-01-01’, ‘yyyy-mm-dd’)),
partition DCS202001 values less than(to_date(‘2020-02-01’, ‘yyyy-mm-dd’)),
partition DCS202002 values less than(to_date(‘2020-03-01’, ‘yyyy-mm-dd’)),
partition DCS202003 values less than(to_date(‘2020-04-01’, ‘yyyy-mm-dd’)),
partition DCS202004 values less than(to_date(‘2020-05-01’, ‘yyyy-mm-dd’))
);

新增分区

如果有间隔，需要删除间隔，
ALTER TABLE dcs2 SET INTERVAL ();
新增分区，
alter table dcs2 add partition dcs202005 values less than(to_date(‘2020-06-01’,‘yyyy-mm-dd’));
然后建立间隔
ALTER TABLE dcs2 SET INTERVAL (numtoyMinterval (1,‘MONTH’));

查询分区表信息

select * from user_tab_partitions a where a.table_name=upper(‘dcs2’);

查询分区数据

select * from dcs2 PARTITION(DCS202003)