【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供22.9.2.3.sql参考,解决您在22.9.2.3.sql学习中工作中的难题,参考学习。
--列表-
列表分区
CREATE TABLE customers_list_list (
customer_id NUMBER(6),
cust_first_name VARCHAR2(20),
cust_last_name VARCHAR2(20),
nls_territory VARCHAR2(30),
credit_limit NUMBER(9,2),
address varchar2(50))
PARTITION BY LIST (nls_territory)
SUBPARTITION BY LIST (address)
SUBPARTITION TEMPLATE
(SUBPARTITION p1 VALUES ('beijing','hangshi'),
SUBPARTITION p2 VALUES ('chengdu','chongqing'),
SUBPARTITION p3 VALUES ('shenyang','jilin'),
SUBPARTITION p4 VALUES (DEFAULT))
(PARTITION east VALUES
('CHINA', 'JAPAN', 'INDIA', 'THAILAND'),
PARTITION west VALUES
('AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND'),
PARTITION other VALUES (DEFAULT));