【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“22.9.2.2.sql”一文,供大家参考学习!
--
列表-散列分区
CREATE TABLE customers_list_hash (
customer_id NUMBER(6),
cust_first_name VARCHAR2(20),
cust_last_name VARCHAR2(20),
nls_territory VARCHAR2(30),
credit_limit NUMBER(9,2))
PARTITION BY LIST (nls_territory)
SUBPARTITION BY hash (credit_limit)
(PARTITION east VALUES
('CHINA', 'JAPAN', 'INDIA', 'THAILAND')
SUBPARTITIONS 4,
PARTITION west VALUES
('AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND')
(SUBPARTITION SUBP1,
SUBPARTITION SUBP2),
PARTITION other VALUES (DEFAULT));