–创建 Range 分区表
CREATE TABLE staffS_p1 (
staff_ID NUMBER(6) not null, FIRST_NAME
VARCHAR2(20), LAST_NAME
VARCHAR2(25), EMAIL
VARCHAR2(25), PHONE_NUMBER
VARCHAR2(20), HIRE_DATE
DATE,
employment_ID VARCHAR2(10), SALARY NUMBER(8,2), COMMISSION_PCT
NUMBER(4,2), MANAGER_ID NUMBER(6),
section_ID NUMBER(4)
)
PARTITION BY RANGE (HIRE_DATE) (
PARTITION HIRE_19950501 VALUES LESS THAN (‘1995-05-01 00:00:00’), PARTITION
HIRE_19950502 VALUES LESS THAN (‘1995-05-02 00:00:00’), PARTITION
HIRE_maxvalue VALUES LESS THAN (MAXVALUE)
);
–创建 Interval 分区表，初始两个分区，插入分区范围外的数据会自动新增分区 CREATE
TABLE sales
(prod_id NUMBER(6), cust_id NUMBER, time_id DATE, channel_id CHAR(1), promo_id
NUMBER(6),
quantity_sold NUMBER(3), amount_sold NUMBER(10,2)
)
PARTITION BY RANGE (time_id) INTERVAL(‘1 day’)
( PARTITION p1 VALUES LESS THAN (‘2019-02-01 00:00:00’), PARTITION p2 VALUES
LESS THAN (‘2019-02-02 00:00:00’)
);
–创建 List 分区表
CREATE TABLE test_list (col1 int, col2 int) partition by list(col1)
(
partition p1 values (2000), partition p2 values (3000), partition p3 values (4000), partition p4
values (5000)
);
–创建 Hash 分区表
CREATE TABLE test_hash (col1 int, col2 int) partition by hash(col1)
(
partition p1, partition p2
);
更多 的表 分区 语法 信息 ，参见 《GBase 8s V8.8_SQL 手册 》中 CREATE TABLE
PARTITION 章节。
