Oracle
要區分range分割和list分割
Create table customer
(
Last_name varchar
area_code number
)
PARTITION BY RANGE (area_code)
(
PARTITION part_
PARTITION part_
PARTITION part_
PARTITION part_
PARTITION part_
);
不像range分割需要一個NUMBER或者DATE標量值
create table
customer
(col values)
partition by list (state_name)
partition yankees values (
partition rebels values (
我們可以看到
From:http://tw.wingwit.com/Article/program/Oracle/201311/18873.html