Oracle分区 (Range + Interval)
–1. 按number形式分区
–1.1 删除表
drop table PART_TAB_CUSTOMER_BY_RANGE cascade;
–1.2 建分区
CREATE TABLE PART_TAB_CUSTOMER_BY_RANGE
(
CUSTOMER_ID NUMBER NOT NULL PRIMARY KEY,
FIRST_NAME VARCHAR2(30) NOT NULL,
LAST_NAME VARCHAR2(30) NOT NULL,
PHONE VARCHAR2(15) NOT N
原创
2020-06-13 14:40:11 ·
601 阅读 ·
0 评论