1.创建分区表语句
CREATE TABLE TABLE_NAME
(
DATA_DATE VARCHAR2(10) NOT NULL,
UUID CHAR(32)
)
PARTITION BY LIST (DATA_DATE)
(
PARTITION P20180131 VALUES ('2018-01-31')
TABLESPACE PARTITION_NAME
PCTFREE 10
INITRANS 1
MAXTRANS 255
);
注: PARTITION_NAME为表空间名称
2.添加分区语句
ALTER TABLE TABLE_NAME ADD PARTITION P20190131 VALUES ('2019-01-31');
3.删除分区语句
ALTER TABLE TABLE_NAME DROP PARTITION P20190131;
4.删除某分区的全部数据
ALTER TABLE TABLE_NAME TRUNCATE PARTITION P20190131;